n8w Posted December 26, 2008 Share Posted December 26, 2008 Can someone please tell me how I can take this exact where but order it by the table.field "favorites.added_date" if($peoplelike){ $sql='SELECT a.* , c.*, d.*, l.printable_name,l.numcode FROM illustrators_table a INNER JOIN users d ON a.user_id = d.user_id LEFT JOIN country l ON d.country_id = l.numcode INNER JOIN (SELECT * from favorites where illustrator_id = "'.$peoplelike.'" GROUP BY user_id) c ON a.user_id = c.user_id WHERE visible = "t" && s_verified = "t" ORDER BY a.count_clicks ASC '; $sql_pagination = $sql; $sql = $sql. ' LIMIT ' . $offset . ',' . $page_limit; } I tried the following but it gives me the error unknown table WHERE visible = "t" && s_verified = "t" ORDER BY favorites.add_date ASC '; Thanks!!!!! Quote Link to comment Share on other sites More sharing options...
gevans Posted December 26, 2008 Share Posted December 26, 2008 favorites is used on the subquery and is not referenced in the main query so cannot be used in the main where claue or order by clause. 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.