Matthew Stuart wrote:
This query is working fine apart from the LIMIT part. I can’t see what is wrong with it, I have tried it in different places and still no luck. Does anybody know why it’s not working?
WHERE (fld_headline LIKE'%userinput%' OR fld_summary LIKE'%userinput%' OR fld_body LIKE'%userinput%') AND fld_category LIKE 'catvalue' AND fld_reldate BETWEEN 'startdatevalue' AND 'enddatevalue' AND fld_show = 1 AND fld_reldate <= NOW() LIMIT 50
ORDER BY fld_reldate
No idea where 'limit 100' comes from. But should you change the order of 'limit' and 'order by', which seems to be the right syntax.
Best
Bao
Error is: You have an arror in your SQL syntax. Check the manual blah, blah … for the right syntax to use near ‘limit 100’ at line 4.
Where ‘limit 100’ has come from I don’t understand, but what ever I put as a LIMIT value it always states ‘limit 100’.
TIA
Mat
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]