SQL HELP NEEDED

Hi all can someone tell me where im going wrong.

I installed  an events catogory mod thats displays in a filter box the names of the catogorys created but it does not display the number of events in the same way the classifieds does please have a look at the file in the zip folder link http://www.irishporn.org/BxDolEvents.zip

and look at line 902 & 795 this is where i have made the modifacation to retrive the number of events in each catagory. but its not working.


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 me

Quote · 29 Aug 2009

Come on guys please help

Quote · 29 Aug 2009
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.