sort in mysql

[Anon]

I have a table with 5 rows and i need to be able to sort them. Will the php sort functions work, if so how would i make them work with a table, and I need it to change all the other rows to match the row that i sorted

thanks gabe

[Anon]

If you can explain your question a little bit better...

If you need to sort or order the results of the database query try sometihng like:

select * from table_name order by column_name

Brett

[Anon]

I have an address book with first name, last name, street, number, and email using mysql. I want to be able to sort them alphabetically.

[Anon]

There are three possible sorts:

1. Sort them IN the database, or
2. sort them for output, say, to an HTML table,
3. or sort them for output to an HTML table, and then allow a re-sort, say, by clkicking on the column title?

[Anon]

k, so what function would i use to sort them in the database

[Anon]

Sorting INSIDE the database is not really necessary. Sorting a query for output to a table is the sort I think you are looking for.

select * from table_name order by column_name [, column_name]