...

View Full Version : Ordering On Two Fields?



gorilla1
01-19-2004, 01:32 AM
OK, i have a mysql table with fields for ip address, and pagename and timestamp. If I select with order by ip address, I get the pages that each ip address visited, but they are in reverse chronological order in the recordset. How do I get them to order chronologically?

G

celestine
01-19-2004, 03:39 AM
You mean like:
select * from table order by ip, pagename ?

gorilla1
01-20-2004, 04:10 AM
celestine,
Thanks, yes!
G



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum