t;OR fieldname like '%$word%' ";
}//close if then
}else{
echo $word;
}//end if
}//close foreach loop
//do the query
//report the results
?>
bastien
From: "Murat BIYIKLI" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] searchengine
I need to split the keyword on search input and generate an sql query,
for ex: the input value is: europe+america,asia
so I want to generate an sql like this:
SELECT * FROM mytable WHERE message LIKE %europe% AND message LIKE %america%
OR message LIKE %asia%
The + (plus) means AND and , (comma