Sort the result of a database...

[Anon]

Ok men, suppose I have a database with about 100 entries.

I show them into a PHP page, but how can I sort them in alphabetical order, or by ID?

Thanks in advance...

Alberto

[gernot]

hello alberto!

i think you're making a sql-statment like this to get the entries:
select * from ttable

to get the rows orderd:

select * from ttable order by [name-id-field]

or

select * from ttable order by [name-text-field]

e.g.

table tarticle(number,name,description)
to get all rows orderd by id (number)
select * from tarticle order by number

by name
select * from tarticle order by name

[Anon]

Just sort them out with SQL

select from table order by id, other_field
select from table order by field

SQL sorts entries faster than PHP does ..

[Anon]

You could also sort'em out with PHP sorting functions ..

ksort

or

asort ..

Just check out the array functions reference ..

http://www.php.net/manual/en/ref.array.php

But I stronly recommend to sort any data from a db using SQL ..

[junebug]

just a note that sorting your results using mysql usually results in faster execution time than using php to sort the results.