ORDER BY question
| From: | Chris Payne | Date: | Thu, 21 Feb 2002 21:15:19 +0000 |
| Subject: | ORDER BY question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17164@lists.php.net to get a copy of this message | ||
Hi there everyone,
Using PHP and MySQL, how can I do an ORDER BY where city = $city? What happens is this, I have a
search engine which works nicely, but I want to bring up the closest matches to the search first at
the top, how can I do this?
Say you enter Munich Hotels, I want all entries with Munich Hotels to appear first before the rest,
any ideas?
Thanks everyone.
Chris Payne
http://www.planetoxygene.com