Go Back   CodingForums.com > :: Server side development > PHP
Reload this Page Ordering On Two Fields?

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 01-19-2004, 01:32 AM   PM User | #1
gorilla1
Regular Coder

 
Join Date: Jun 2002
Posts: 544
Thanks: 0
Thanked 0 Times in 0 Posts
gorilla1 is an unknown quantity at this point
Ordering On Two Fields?
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
gorilla1 is offline   Reply With Quote
Old 01-19-2004, 03:39 AM   PM User | #2
celestine
Regular Coder

 
Join Date: Oct 2003
Location: Australia
Posts: 112
Thanks: 0
Thanked 0 Times in 0 Posts
celestine is an unknown quantity at this point
You mean like:
select * from table order by ip, pagename ?
celestine is offline   Reply With Quote
Old 01-20-2004, 04:10 AM   PM User | #3
gorilla1
Regular Coder

 
Join Date: Jun 2002
Posts: 544
Thanks: 0
Thanked 0 Times in 0 Posts
gorilla1 is an unknown quantity at this point
celestine,
Thanks, yes!
G
gorilla1 is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


« Previous Thread | Next Thread »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:36 AM.
Advertisement
Log in to turn off these ads.