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


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to