Checkboxes and passing variables

[zenaphex]

I have three checkboxes:

"descriptions"
"issues"
"solutions"

"descriptions" is checked by default. I want to pass these checkbox names as $options (or in this case, field names) to a MySQL query. I would assume that is possible. The query would be like:

mysql_query("SELECT * FROM solution WHERE MATCH(".$options.") AGAINST (".$keywords.") IN BOOLEAN MODE");

The thing is those names need to be seperated by commas and I am unsure on how to do that or even the best way to do it.

Also when I send search words to the $keywords variable do I need to do something to that variable before I insert it into the mysql_query() string? I was asking because being a search it may have quotes and other weird characters in it and such.

If anyone could help me out I would greatly appreciate it. Thanks in advance.

[TTT]

you have to use comma separated list and also use ' ' when variable is string (sql) ... i'm not sure how does match/against work.... seems that something is missing... WHERE someField NOT IN ('the,list')??

mysql_query("SELECT * FROM solution WHERE MATCH('$options') AGAINST ('$keywords') IN BOOLEAN MODE");