Re: list entries alphabetically
| From: | Miles Thompson | Date: | Wed, 15 Aug 2001 21:11:29 +0000 |
| Subject: | Re: list entries alphabetically | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-11407@lists.php.net to get a copy of this message | ||
Andrius,
Seriously, work through a SQL tutorial and you'll have all your questions answered.
Here's a good link: http://developer.ecorp.net/sqltut.htm
just remember that MySQL doesn't support sub queries.
The ORDER clause in a SQL SELECT statement determines the order of the returned records. If there is a "friends" table in your database, with fields like
firstname
lastname
birthdate
phone
cell
if you wanted to select all entries, ordered alphabetically, you would use this statement
select * from friends order by lastname, firstname
by birthdate?
select * from friends order by birthdate
Quite simple and clear - the beauty of SQL
Miles
At 10:44 PM 8/15/01 +0200, Andrius Jakutis wrote:
Hello again, How to list entries alphabeticall way? Using MYSQL. Thanks