bugmenot Posted July 28, 2015 Share Posted July 28, 2015 Hello every one I m using a localhost ( XAMPP ) to run this qeury whene a run the query like this it works SELECT users.*, topics.* FROM `users` LEFT JOIN topics ON topics.topic_author = users.id order by topic_edit_time ASC but whene I add " WHERE " it doesn't SELECT users.*, topics.* FROM `users` LEFT JOIN topics ON topics.topic_author = users.id order by topic_edit_time ASC WHERE id='$tid' and Iget this error message :: 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 id=1' at line 1 please help Thanks, and have a good day Quote Link to comment Share on other sites More sharing options...
requinix Posted July 28, 2015 Share Posted July 28, 2015 WHERE has to come before the ORDER BY. Quote Link to comment Share on other sites More sharing options...
bugmenot Posted July 28, 2015 Author Share Posted July 28, 2015 SELECT users.*, topics.* FROM `users` LEFT JOIN topics ON topics.topic_author = users.id WHERE topic.id=$tid order by topic_edit_time ASC didn't work, I get :: Unknown column 'topic.id' in 'where clause' Quote Link to comment Share on other sites More sharing options...
Solution NomadicJosh Posted July 28, 2015 Solution Share Posted July 28, 2015 (edited) In your initial query, you had WHERE id='$tid', but then in the second query when you fixed where clause, you have topic.id=$tid. So first, which one is it? If it is the second one, shouldn't it be topics.id=$tid, with an (s)? Edited July 28, 2015 by parkerj Quote Link to comment Share on other sites More sharing options...
bugmenot Posted July 28, 2015 Author Share Posted July 28, 2015 In your initial query, you had WHERE id='$tid', but then in the second query when you fixed where clause, you have topic.id=$tid. So first, which one is it? If it is the second one, shouldn't it be topics.id=$tid, with an (s)? Stupid mistake You Saved my life, thank you Quote Link to comment 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.