: "Chris Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 6:58 AM
Subject: Re: [PHP-DB] Searching results of results
> Hi there,
>
> Thanks for your help on this it's appreciated, i'll look into temporary
> tables tomorrow
Hi there,
Thanks for your help on this it's appreciated, i'll look into temporary
tables tomorrow and see what I can do. Just curious, why is the method you
have shown below better than the method I used previously? Is it a speed
thing or is it more logical? I am learning different methods of
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
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 $of
