AKalair Posted September 4, 2009 Share Posted September 4, 2009 Hi guys, My query keeps throwing an error its the ORDER by clause thats causing it. $getlateststories = mysql_query("SELECT * FROM reviews, news LIMIT 0, 5 ORDER BY creationdate") or trigger_error('Unable to get latest stories', E_USER_ERROR); I have verified that the field is called "creationdate" in both tables Can anyone point me in the right direction? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/173162-select-query-sort-problem/ Share on other sites More sharing options...
corbin Posted September 4, 2009 Share Posted September 4, 2009 ORDER BY goes before LIMIT. Quote Link to comment https://forums.phpfreaks.com/topic/173162-select-query-sort-problem/#findComment-912765 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.