[SOLVED]Dual tableselect problems
Posted: Sun Dec 18, 2005 1:36 pm
This query is giving me problems, I wonder if someone can tell mewhat I'm doing wrong.
The error that I get is: Unknown column 'favourites.user_id' in 'where clause'.
Help appreciated. Thanks.
Code: Select all
mysql_query("SELECT * FROM `users` AS users, `favourites` AS favourites WHERE
`favourites.user_id` = $this->userid AND `favourites.type` = '$type'
ORDER BY `users.popularity` DESC");Help appreciated. Thanks.