Hi there everyone,

Say I do a simple search as follows:

$query = "SELECT * FROM search WHERE 
(description LIKE '%$test%' OR state LIKE '%$test%' OR city LIKE '%$test%' OR fname 
LIKE '%$test%') AND (category = '$category' AND country = '$country' AND type = 
'$type') ORDER BY city ASC LIMIT $offset, $item_perpage";

and this brings up 1000 results, how can I then do another search based on THESE 
search results only?  That is, it only searches the results it currently has and 
doesn't search the DB for other entries at the same time?

Thanks for your help


Reply via email to