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 chapter_number' at line 1--select id,pub_id,book_id,chapter_number,name from chapters where book_id= order by chapter_number