Posted by J.O. Aho on 10/14/88 11:55

Seansan wrote:

> I have this query below and the SELECT COUNT statements are generating
> errors in MySQL with php and I have no clue why. I would like to be
> able to do this because this also works for other DB's. Any ideas?

Without even looking at the query, I would guess you have MySQL 4.0 or older
version, which don't support subqueries, what you need to do is to upgrade
your MySQL to a later version, 5.0 which should be the current stable one.

For more info about subquery errors, check this page at mysql.com:
http://dev.mysql.com/doc/refman/5.0/en/subquery-errors.html



//Aho

[Back to original message]