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]