Welcome to xCrud Community - Data Management and extended PHP CRUD

[ben74]

Hello guys,

Is there a workaround to be able to run "NOT IN" operator with xcrud->where method?

This for example doesn't work:

$buyername_not_in_string = "'a','b','c'";
$xcrud->where('buyers.buyer_name NOT IN ', $buyername_not_in_string);

it ends up with: Uncaught mysqli_sql_exception: Unknown column 'buyers.buyer_name NOT IN' in 'where clause'

I can probably transform my NOT IN in a couple != but it's not as elegant...

Thanks for any tip ;-)

 

[DaDo]

Sorry for delay too busy you can try using this :

$xcrud->where("buyers.buyer_name NOT IN $buyername_not_in_string");