Prepared Statement Not In Function

[Adamhumbug]

I have an array that has comma sep values.

I am wanting to run a select statement that includes a NOT IN function.

SELECT user_firstname, user_lastname, user_id
                            FROM ssm_user
                            WHERE user_role_id = ? and where user_id NOT IN(?)

Is this possible, oir does the ? just represent a literal string.

If so do i need to convert the array to a string before running the above?

[Barand]

If there are are 10 values in your array then you need 10 placeholders i.e. NOT IN (?,?,?,?,?,?,?,?,?,?) then

$stmt->execute( $yourarray );

 

[mac_gyver]

use (NOT) FIND_IN_SET(str,strlist). the strlist parameter can be supplied via a single prepared query place-holder.

 

[Barand]

I rarely use sets so I keep forgetting about the FIND_IN_SET() function

[Adamhumbug]

A bit of working out here but that worked perfectly.

 

Thank You