chris smith-9 wrote:
> Doing this is actually rather easy.
> Replace this:
> SELECT e.id, e.title, e.subheading, eta.start_timestamp,
> eta.end_timestamp, e.zip, e.bold, e.outline, e.color, e.subheading,
> COUNT(esa.id) AS subcat_count
> SELECT COUNT(e.id) AS count
> Or am I completely missing the point?
I've tried that. It doesn't work for two reasons:
1) the ORDER BY subcat_count in the original query would cause an error in
2) removing that ORDER BY clause to make valid SQL still results in a set of
rows - one for each of the original rows - rather than a single COUNT value
for the entire query. The values for COUNT range from 1 to 4 depending on
how many subcategory ASSOC records (esa) are connected to a particular e.id.
View this message in context:
Sent from the Php - Database mailing list archive at Nabble.com.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php