Qry Err3 : select idx,name from goods where category='' and bLimit<3 and setVal> order by setVal asc limit 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by setVal asc limit 1' at line 1