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 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. Link to comment https://forums.phpfreaks.com/topic/173162-select-query-sort-problem/#findComment-912765 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.