RE: [PHP-DB] Order By for search results ???
| From: | Rick Emery | Date: | Thu, 18 Oct 2001 17:46:25 +0000 |
| Subject: | RE: [PHP-DB] Order By for search results ??? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13498@lists.php.net to get a copy of this message | ||
Maybe I'm slow...
I'm trying to decipher what you're trying to do.
Show us your table layout
Show us your search criteria and code
Show us a dump of your table so we can see what the data look like
-----Original Message-----
From: Chris Payne [mailto:chris@planetoxygene.com]
Sent: Thursday, October 18, 2001 12:08 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Order By for search results ???
Hi there everyone,
I am happy, I have my search engine working almost perfectly (Touch wood :-)
but there is one problem. When I search - say for Backpacking in Australia
it doesn't bring up the results in that order as I have to order by country,
city or whatever. What I want to know is, how do I ORDER BY and then my
search results so that I get the nearest matches at the top of the search?
Thank you all for your help, this list is the best place to be for PHP :-)
Chris