Re: select query help

[Chis Florinel]

Here is an example:

$string = "lether shooo";

$words = str_word_count($string,1);
//for debug you can check the words
//print_r($words);

$moreSQL = "";
foreach($words as $word) {
$moreSQL .= " AND (prodname like '%".mysql_real_escape_string($word)."%' OR skuno LIKE '%".mysql_real_escape_string($word)."%') ";
}
$sqlQuery = "SELECT * FROM ez_product WHERE 1 $moreSQL";
echo $sqlQuery;

This query will display all the records containing in prodname or skuno all the search words...
if you want at least one word:

$moreSQL .= " OR (prodname like '%".mysql_real_escape_string($word)."%' OR skuno LIKE '%".mysql_real_escape_string($word)."%') ";
...
$sqlQuery = "SELECT * FROM ez_product WHERE 0 $moreSQL";