* Thus wrote Jonathan Haddad: > The only problem there is when you group the LEFT JOIN pictures that > have a count of 0 return a count of 1. Unfortunately there's no single > query that I figured out when I did this same project that would give > accurate results.
SELECT pics.*, pic_comments.*, count(*) + if(pic_comments.pic_id = NULL, -1, 0) Curt -- First, let me assure you that this is not one of those shady pyramid schemes you've been hearing about. No, sir. Our model is the trapezoid! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
