In_array

[KingOfHeart]

How do I use this function in a MYSQL search, and I don't want to use a JOIN command.

 

$ignore = array(82,11,75,95);

 

Select * FROM {$db_prefix}messages Where !in_array(ID_BOARD,$ignore) Order BY posterTime Desc Limit 300

[kickstart]

Hi

 

If building it up in php then try this:-

 

$ignore = array(82,11,75,95);

$sql = "Select * FROM {$db_prefix}messages Where ID_BOARD NOT IN (".implode(',',$ignore).") Order BY posterTime Desc Limit 300";

 

All the best

 

Keith

[fenway]

FIND_IN_SET() does this too, if it's comma-separated.