Re: ORDER BY question
| From: | pixelpeter | Date: | Thu, 21 Feb 2002 22:36:00 +0000 |
| Subject: | Re: ORDER BY question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-17170@lists.php.net to get a copy of this message | ||
Good article on phpbuilder.com
Slapping together a search engine for your database is easy with PHP and
MySQL
http://phpbuilder.com/columns/clay19990421.php3
[ p i x e l p e t e r ]
pixelpeter@web.de
"Chris Payne" <chris@planetoxygene.com> schrieb im Newsbeitrag
news:000c01c1bb1c$e049dce0$0200a8c0@chris...
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