variable must be equal to serveral fields

[Shadeless]

I have this search form where some1 can sellect category's to search in.

The selected category is forwarded as $type

1 of the category's is all,

the search query looks like this:

$query = "SELECT * FROM $tablename WHERE ".$type." LIKE '%".$keyword."%'";
[code=php]

what i want to reach is when some1 selects all is making $all search in all fields of the database.

how can i define $all, in a way that it will search all database fields (the oter category's each match 1 field in the database)

i tried to define $all as

$all = ['category'], ['Machine_Type_nr'],[' Description'], ['Software'],['Firmware'], ['Originator'], ['Long_description'], ['Short_description'];

but that doesn't work at all :D as suspected.

does any1 know if it actualy is possible in this way (there must be, but haven't found it yet, search didn't returned anything to me about it, or i am a lousy searcher)

thx in advance

[nnichols]

I would suggest that you build it manually -

$query = "SELECT * FROM $tablename WHERE category LIKE '%".$keyword."%'";
$query .= "OR Machine_Type_nr LIKE '%".$keyword."%'";
$query .= "OR etc, etc";

or you might want to look at fulltext searching -

http://www.mysql.com/doc/en/Fulltext_Search.html

Good luck! 😉

[ednark]

ooo..... good post... i hadn't even noticed the full text search thing before...

[Shadeless]

thx will let u know outcome tomorow, for now i gona take a brake.. since my neck is as stiff as .... a crowbar.