Thats what I thought, however my code:
PHP Code:
WHERE usergroupid IN ($groupids)
OR membergroupids IN ($groupids)
OR FIND_IN_SET('$groupids', membergroupids)
only grabs users in group 6, and not 6,15 like I have selected.
--------------- Added [DATE]1255005593[/DATE] at [TIME]1255005593[/TIME] ---------------
n/m, I may have found my long outstanding issue. I can't use an IN when searching a DB column that has data in it such as 5,6,2. I have to use the FIND_IN_SET, but bigger yet, had to create loop to look through the array and then use the find in set. Phew!
10-08-2009, 11:25 AM
Threaded Mode