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");
The error that I get is: Unknown column 'favourites.user_id' in 'where clause'.
Help appreciated. Thanks.
Last edited by evilmonkey on Sun Dec 18, 2005 5:05 pm, edited 1 time in total.
Iseem to have finxed it. The problem was with the ` character around favourties.user_id. If someone could elaborate on when those ticks areneeded, I'd really appreciate it.
evilmonkey wrote:Iseem to have finxed it. The problem was with the ` character around favourties.user_id. If someone could elaborate on when those ticks areneeded, I'd really appreciate it.