I am using this query in my code:
select * from REQUESTINFO rq, REPLY r where rq.id = r.requestid order by rq.date desc limit 0, 10
Unfortunately it does not limit the records to the first 10. Any idea what I am doing wrong? Should the 'limit' come before the 'order'? Am I just plain dumb?