Posted by Seansan on 10/14/00 11:55

J.O. Aho wrote:
> 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

Thanks for your answer. I have version MySQL 3.23.58, this is probably
it. Anybody any hints on how to fix this for lower versions?

[Back to original message]