Alex1646 Posted March 18, 2011 Share Posted March 18, 2011 Im using this mysql verison: 5.1.53 Im trying to select something from my database with a where clause. Here is my code: SELECT * FROM story_info ORDER BY added WHERE cat='drama' When I add or die(mysql_error()) I get 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 'WHERE cat='drama'' at line 3 Quote Link to comment https://forums.phpfreaks.com/topic/230975-help-with-where-clause-syntax-added-sql-verison-so-please-check-back/ Share on other sites More sharing options...
Pikachu2000 Posted March 18, 2011 Share Posted March 18, 2011 The ORDER BY clause comes after the WHERE clause. Quote Link to comment https://forums.phpfreaks.com/topic/230975-help-with-where-clause-syntax-added-sql-verison-so-please-check-back/#findComment-1189003 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.