|
|
Posted by J.O. Aho on 10/08/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
Navigation:
[Reply to this message]
|