Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aiden857181
Starting Member
3 Posts |
 Posted - 2009-08-29 : 13:28:18
|
| Hi all can someone tell me where im going wrong.I am trying to display the number of catogorys stored my database via the page on this link http://www.irishporn.org/BxDolEvents.zip. Please see the code in the page at http://www.irishporn.org/BxDolEvents.zip on line 795 & 902 is the mod i made but not working. WHERE OH WHERE AM I GOING WRONG.This is the code on line 902 $iCatCount = (int)db_value("SELECT COUNT FROM `SDatingEvents` WHERE `EventCategorie`");This is the code on line 795 <b>'._t($aPreValues['EventCategorie']['10']['LKey']).'</b></a><b><?php {$iCatCount} php?></b></td>if you go to http://www.irishporn.org/classifieds.php you will see beside the word Antrim it displays the number of entries stored in the database catogory.i am trying to do the same on this page http://www.irishporn.org/events.php scroll down to the bottom of the screen to see the list. Notice it has not got the number of catogory entries beside it.This is driving me mad please help |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-08-30 : 10:56:57
|
$iCatCount = (int)db_value("SELECT COUNT(*) FROM `SDatingEvents` WHERE `EventCategorie`");
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-08-30 : 10:57:51
|
WHERE `EventCategorie` = what?
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
HELP PLEASE