online dating hack - need some help with profile fields.

[T3MEDIA]

I am almost finished on a online dating add on for vB (actually it works) but not the way I want it to...

Oh KAY! Multiple selection boxes are like to the ^2 so...
Asian = 1
Black = 2
Cauc = 4
India = 8 and so on.... Now I made some code but its not doing the desired results.

PHP Code:

// Race
              if(($bbuserinfo['field23'] != '') AND ($bbuserinfo['field23'] != 1)) 
              {
              $attractionrace = $bbuserinfo['field23']/2;
              }
              else
              {
               $attractionrace = $bbuserinfo['field6'] ;
              } 


I drop $attractionrace into my SQL query...

PHP Code:

AND ".TABLE_PREFIX."userfield.field6= '$attractionrace' 


but what happends is... if for example you pick your attracted to 'Asians' and Indian's (which would result in the number 9) my search results only bring back members who are MIXED with Asian and Indian not all Asians and All Indians... How do I fix that? I assumed doing 1,8 but that obviously does not work. The amount of variations is like winning at the horse races so I rather do it with variables instead of hard coding.

To be honest that is the only glitch, I will release the file as beta soon. No vb php is needed to hack and there is minor template work.