Posted by J.O. Aho on 09/30/45 11:55

Seansan wrote:

> 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?

You need to make two extra queries and fetch the "total" and "unread"
separately from the main select and then in php merge the three selects to
your result array (in case you do save thing in a such).

If this won't be an option for you, then you need to upgrade to MySQL 4.1.


//Aho

[Back to original message]