[SOLVED] Ordering problem

[bri4n]

Hi guys!

 

This is a simple one, but I just can't seem to figure out what I've screwed up!

 

I have a form that the user fills in (and in the background I store the time/date that the form was submitted into a MySQL database). That's ok...everything works fine there. But what I am wanting to do is to list all the people that have submitted the form, and list them according to the time they submitted the form. here is what I have, but I just can't seem to see what's wrong with the code:

 

$query = ("SELECT firstname, lastname, email, phone FROM userinfo ORDER BY time") or die(mysql_error());

$result = mysql_query($query);

 

Any ideas as to what I've stuffed up?  ???

 

TIA

Brian 

[The Little Guy]

$query = ("SELECT firstname, lastname, email, phone FROM userinfo ORDER BY time DESC") or die(mysql_error());

$result = mysql_query($query);

[bri4n]

Hi Little Guy!

 

Thanks for that...I changed the "DESC" to "ASC" and it works perfect.

 

Thanx,

Brian :-)