Re: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

[Peter Brawley]

The mysql_query() call elicited an error, and your code failed to catch it. Minimal error trapping would be ...

$result = mysql_query("SELECT c.category_id, c.category_name, COUNT(photo_id) FROM gallery_category AS c LEFT JOIN gallery_photos AS p ON p.photo_category = c.category_id GROUP BY c.category_id") or exit( mysql_error() );

Better: write a try/catch block.

PB