Jump to content

Help with where clause syntax! ((Added sql verison so please check back)


Recommended Posts

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


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.