search engine for a database

[Fking]

i have a search field where the user types a keyword
for example "nokia 6600"

i have a table, with field for the brand name "nokia" and field for the modelname "6600"

so i guess i need first to join the values of the brand name and model name fields, and then do a search on them with
LIKE %nokia%6600%

how to do it?

p.s.
currently i'm doing search only for the model name using this line

$result=mysql_query("SELECT markaid, MarkName, modelid, ModelName, ModelPic, telinfo, cena, grad, kontakti, date FROM $table
WHERE ModelName LIKE '%$keyword%';");

[jansky]

why not try adding OR in your query

where ModelName LIKE '%$keyword%' OR ModelBrand Like '%$keyword%'

[Fking]

because it's good the search field to be only one
not separate field for model and brand

[Fking]

isn't there a way to join the values of the ModelName and ModelBrand columns and do the like % statement on the joined value?

[leatherback]

How about using explode() to split the values from the search engine box, and doing a search for the combination of each words that was submitted against both colums in the database?