Re: how to do a search in mysql database for multiple keywords??
| From: | Intruder | Date: | Sat, 13 Oct 2001 14:20:01 +0000 |
| Subject: | Re: how to do a search in mysql database for multiple keywords?? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-70983@lists.php.net to get a copy of this message | ||
NB> code to split up the variable into an array:
NB> $search = trim($search);
NB> the SQL:
NB> SELECT id, rubrik, tid, datum, kategori, kopsalj, bildnamn FROM annons
NB> WHERE lan LIKE '$landropdown' AND kategori LIKE '$katdropdown' AND
NB> kopsalj = $kopsalj AND (rubrik IN($search) OR text IN($search)) ORDER BY
NB> datum DESC, tid DESC LIMIT $offset, $end
<?php
$a = explode(" ",$search);
$sql="SELECT [DISTINCT] id, rubrik, tid, datum, kategori, kopsalj, bildnamn
FROM annons
WHERE lan LIKE '$landropdown' AND
kategori LIKE '$katdropdown' AND
kopsalj = $kopsalj";
while ($item=array_pop($a)) {
$sql.=" AND rubrik LIKE '%$item%' OR text LIKE '%$item%'"
};
$sql.="ORDER BY datum DESC, tid DESC LIMIT $offset, $end";
};
?>