Alex1646 0 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 Link to post Share on other sites
Pikachu2000 121 Posted March 18, 2011 Share Posted March 18, 2011 The ORDER BY clause comes after the WHERE clause. Link to post Share on other sites
Recommended Posts
Archived
This topic is now archived and is closed to further replies.