View Single Post
Old April 24th, 2005, 03:33 PM   #8 (permalink)
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 71,693
$query = "SELECT SUM(views), SUM(filesize), count(*) FROM {$Globals['pp_db_prefix']}photos";
$totalv = ppmysql_query($query,$link);
list( $totalviews, $diskuse, $totalphotos ) = mysql_fetch_row($totalv);
ppmysql_free_result($totalv);

The query that shows how many photos is simply a count of how many photo rows in the mysql table so yes a photo is counted once when uploaded to multiple cats
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote