[ericgtr]

Not tested and I am not sure about your query but you can start with something like this:

PHP Code:

$total_photos = $db->query_first('
Select userid, user, Count(*) AS num from photos 
Group BY userid;
');
$allphotos = number_format($total_photos ['count']); 


Then call it up in your template with this

$total_photos[count]

Again, untested as I don't use photopost but it gives you something to play with.