Second table dictates first table...

[Anon]

Hi, and thanks in advance for any help provided...

Take a look at this sql statement:

$sqlone = "SELECT * FROM message WHERE message.from != 'userone' && message.from != 'userfour'";

See how i remove particular items from the selection using the NOT LIKE symbol?

My question is... what if i have alot more than just two items that i wanted to remove?
For example, what if i had a whole table with users that i wanted to ignore, and for every member, the list of ignored users is different. How do i incorporate that?

Any help is greatly appreciated...thank you

Mike

[crimaniak]

Statement for ignore table:

CREATE TABLE ignoreList (ignoreName VARCHAR(255) PRIMARY KEY);

Seletc messages from users not in the ignore list:

SELECT * FROM message LEFT JOIN ignoreList ON message.from=ignoreName WHERE ignoreName IS NULL

[Anon]

Excellent...

Thanks man.