querry for secondary usergroups??

[Dankness]

Hello i have been tryin to figure out the proper operator to modify all users in a secondary user group. Which the table row would be

TABLE_PREFIX . 'user where membergroupids = 'is this possible?';

Basicly, i just need a method to check if say #1 is inside of the array stored in membergroupids.

Thanks
Shawn

[Marco van Herwaarden]

Check the MySQL function FIND_IN_SET()

http://dev.mysql.com/doc/refman/4.1/en/string-functions.html

[Dankness]

Check the MySQL function FIND_IN_SET()

http://dev.mysql.com/doc/refman/4.1/en/string-functions.html

ok thank you for the tip, i have figured some of this out when i run the following querry in phpWebAdmin then it lists what im looking for.


select * from vb_user where FIND_IN_SET ( '6', membergroupids ) > 0";


but when i use it in a php querry then it gives a invalid sql syntanx


$db->query("select * from ".TABLE_PREFIX."user where FIND_IN_SET ( '" . $_POST['usergroup'] . "', membergroupids ) > 0");


EDIT SOLVED:

After playing around with it for awhile i found this which works


$db->query_read("SELECT * FROM ".TABLE_PREFIX."user as a WHERE FIND_IN_SET('{$_POST['usergroup']}', a.membergroupids) ");

[Marco van Herwaarden]

I hope you are not planning to use that query like this in your final code?

Never use unsanitised variables in a query (like $_POST).