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 doing
things so I would really appreciate your input :-)
Thanks for everything.
Chris
> 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
