mysql_query LIMIT doesn't work

[ayok]

Hi,

A short question. I've got this query

$fetch = mysql_query("SELECT * FROM table LIMIT 0,3 ORDER BY date DESC")or
die(mysql_error());

But then I get mysql error for the limit. I think because I order it based on the date.

 

Could anybody tell why and how to fix this?

 

Thank you,

ayok

[aebstract]

$fetch = mysql_query("SELECT * FROM table ORDER BY date DESC LIMIT 0,3")or
die(mysql_error());

 

Try this, and I'm not sure about the 0,3.. I've always used a solid number such as 0 or 3, but I think it may have been the order you had it wrote out in.

[discomatt]

0,3 is fine, but yes, limit must be after group/order

 

http://dev.mysql.com/doc/refman/5.0/en/select.html