Help with subquery! 1

[borgrulze]

i need some help with is query.

SELECT * FROM pollquestions WHERE timeinserted=(select max(timeinserted) from pollquestions);

the inner query, select max(timeinserted) from pollquestions, works fine but gives an error when used with the outer query.

timeinserted is of type datetime.

 

[TonyGroves]

Unfortunately, sub-queries are not supported by MySQL until version 4.1 (currently alpha).

If you only want the most recent record, you could simply use:[tt]
SELECT * FROM pollquestions ORDER BY timeinserted DESC LIMIT 1;[/tt]

If you want all matching records, then the simplest way I can think of is to use two queries:[tt]
SELECT @d:=MAX(dateinserted) FROM pollquestions;
SELECT * FROM pollquestions WHERE timeinserted=@d;[/tt]

-----
ALTER world DROP injustice, ADD peace;