You could select these results into a temporary table
and then query that table. Look at the mysql.com docs
and check out the CREATE TEMPORARY TABLE. You can
select data right into the table and the table is
erased when the connection closes. 

But first it looks like cleaning up your query would
probably be the best way to get what you want.

try something like    

$query = "SELECT * FROM search WHERE ";

if ($description) {
   $query .= "description LIKE '$description%' AND ";
}
if ($state) {
   $query .= "state = '$state' AND "; }
if ($city) {
   $query .= "city = '$city' AND "; }
if ($fname) {
   $query .= "fname = '$fname' AND "; }

$query .= "(category = '$category' AND country =
'$country' AND type = '$type') ORDER BY city ASC LIMIT
$offset, $item_perpage";

have fun,
olinux


--- Chris Payne <[EMAIL PROTECTED]> wrote:
> 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
> 
> Chris
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to