Multiple Checkboxes Search Help ?

[RobinHood]

Hi,

I'm trying to create a new search script that would search into the DB using checkboxes. I just can't figure out how I would do that in MySQL.

Here is the search page: http://www.findacupid.com/search.php

This is what the "lookingfor" field data looks like: "2 3 5 6 8 9 12 15".

How would I make it so it can search for a user that has only 5 and 15 in that field?

Thanks for your help.

[Tekton]

Well if you are storing it as a string like that, I'd explode the string, and then search through it with a while() or something...

PHP Code:

$id=0;
$temp = explode(" ", $fullstring);
while ($search = fetch_array($temp)){
// check values with $search[$id]
$id++;
} 


I could probably go a little more in depth for the searching part... if this is really the way you'd want to do it, which I'm not too sure about. I'm not exactly the cleanest coder out there...

I'd assume you want to compare if it was == to a value that you store in another var.