can't find what is wrong in this sql query

[bugmenot]

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

 

[requinix]

WHERE has to come before the ORDER BY.

[bugmenot]

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'

[NomadicJosh]

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)?

[bugmenot]

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