Count Number of Images in category

Phoca Gallery plugins - plugins for Phoca Gallery extension
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48403
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Count Number of Images in category

Post by Jan »

Hi, I think this must be customized, so the sql query needs to be changed - count must be added, but not sure, if it should be added as next sql query because of different if clauses in the sql query :-(

Jan
If you find Phoca extensions useful, please support the project
Skyscraper
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 30 Apr 2011, 16:29

Re: Count Number of Images in category

Post by Skyscraper »

you can try add this in your tmpl :

$total = mysql_query("select count(*) from jos_phocagallery");
$total1 = mysql_fetch_array($total);
echo '<div style="width:775px; margin: auto;" align="right">ALL:'.$total1[0].'</div>';
Post Reply