|
|
Posted by charliefortune on 11/04/05 16:33
I would like to SELECT, matching a spending limit, a currency, and then
any matched searchwords. I'm not sure if my query below will consider
one searchword match enough to SELECT the item. All 3 clauses must be
met. How would I word my query please, anyone ?
$query = "SELECT id,tracking_url,product,price,description,id_merchant
from product WHERE price < $maxspend AND id_currency = $currency AND
keywords LIKE '%$searchword%' OR product LIKE '%$searchword%' OR
description LIKE '%$searchword%';"
Navigation:
[Reply to this message]
|