Posted 25 August 2006 - 11:52 AM
is this correct as i cant get it to work
Posted 25 August 2006 - 12:08 PM
select selected_id from table2 where 1
That isn't a valid sql query. Aside from your subselect being jacked, it should work.
SELECT * FROM table1 WHERE members_id NOT IN (SELECT selected_id FROM table2);
Posted 25 August 2006 - 12:12 PM
WHERE websites_id NOT
LIMIT 0 , 30
#1064 - 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 'SELECT websites_hits_id
FROM websites_hits ) LIMIT 0, 30' at li
Posted 25 August 2006 - 01:53 PM
SELECT * FROM `table` WHERE 1is a valid query, try it.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users