Re: [PHP] Grouping records

2008-11-04 Thread Yeti
I have transactional records with the following structure Records of what kind? Is it SQL? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Grouping records

2008-11-04 Thread Matthew Halpin
:[EMAIL PROTECTED] Sent: Wednesday, 5 November 2008 12:28 AM To: Matthew Halpin; PHP Generals Mailing List Subject: Re: [PHP] Grouping records I have transactional records with the following structure Records of what kind? Is it SQL? -- PHP General Mailing List (http://www.php.net

Re: [PHP] Grouping records

2008-11-04 Thread Yeti
Ok, this looks quite databasey so I guess you will have a query like: SELECT Rowid, Person, Timediff FROM transitional_records ORDER BY Timediff I don't know what DB you use. let's say it is MySQL (the others are similar). Always provide such things when asking for advice. Else it's not easy to

[PHP] Grouping records

2008-11-03 Thread Matthew Halpin
Hi, I have transactional records with the following structure Rowid TimePerson TimediffGroupid 1 20:22:49Bob 2 20:22:49Bob 0 3 20:22:50Bob 1 4