Sorting MySql results

Hey Guys!

I want to sort the results from a MySql Command by a certain row.

e.g. I want to display the coloumn with the lowes timestamp first or i want to display only the latest entry in the result array. I fetch my results like that:

$result=mysql_query("SELECT * FROM $wp_start")
$num=mysql_numrows($result);

Somewone has a short hint?

i really need just a very tiny - tiny - icy - littely - hinti - pinty
never mind the last sentence. im allready wired.

btw: the page im working on is : http://www.kummerkaestchen.com/pics

maybe anybody could move this thread to mySql Board. I just realized it better on that board.

Add "ORDER BY" to your SQL based on the field you want to sort.

SELECT * FROM $wp_start ORDER BY myField

Use "DESC" to reverse the sort

SELECT * FROM $wp_start ORDER BY myField DESC

Originally posted by Chris Hunter
or i want to display only the latest entry in the result array

to get just the latest entry with an sql command, use the following...

SELECT * FROM $wp_start ORDER BY timestampfield DESC limit 1

cool my friends - thanks a lot