angela5
-
Posts
1 -
Joined
-
Last visited
Never
angela5's Achievements
Newbie (1/5)
0
Reputation
-
Please help just with this: Select all users which are in table "listingsdb" and are Not in "userfavoritelistings"... $searchSQL = "SELECT distinct(" . "listingsdb.listingsdb_id), " . "listingsdb.userdb_id, " . "listingsdb.listingsdb_title FROM " . "listingsdb, " . "userfavoritelistings " . $string_table_list . " WHERE (listingsdb_active = 'yes') " . $string_where_clause . " AND (" . "userfavoritelistings.listingsdb_id = " . "listingsdb.listingsdb_id) "; $searchSQLCount = "SELECT COUNT(distinct(" . "listingsdb.listingsdb_id)) as total_listings FROM " . "listingsdb, " . "userfavoritelistings " . $string_table_list_no_sort . " WHERE (listingsdb_active = 'yes') " . $string_where_clause_nosort . " AND (" . "userfavoritelistings.listingsdb_id = " . "listingsdb.listingsdb_id) ";