sneakyimp wrote:

chris smith-9 wrote:
Doing this is actually rather easy.

Replace this:

SELECT, e.title, e.subheading, eta.start_timestamp, eta.end_timestamp,, e.bold, e.outline, e.color, e.subheading, COUNT( AS subcat_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
the SQL
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

Ah - that would be the group by doing that.

Removing those:

GROUP BY ORDER BY subcat_count DESC,

Does that get you what you want?

If it gives you one result - make sure it's right. Change a few id's, make sure they match up to what your other query returns.

Postgresql & php tutorials

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to