Re: [PHP] Get next record

2001-03-13 Thread Christian Reiniger
On Monday 12 March 2001 20:38, you wrote: > How can one get the next record to compare two fields... I want to > check if the date of the first record matches the date of the next > record with the least amount of code... SELECT First.id, Second.id from mytable First, mytable Second WHERE (First

Re: [PHP] Get next record

2001-03-12 Thread Tanya Brethour
Umm if you are talking about records in the sense of a table.. you could do something like "SELECT record_id,record_date FROM table" and then go through the array and compare the dates. You only do one query from the database and then you know which records match by hanging onto their record_id.

RE: [PHP] Get next record

2001-03-12 Thread Boget, Chris
> How can one get the next record to compare two > fields... I want to check if the date of the first record > matches the date of the next record with the least amount > of code... You are going to have to work with row pointers. If you are using mySQL, look at the function: mysql_res

[PHP] Get next record

2001-03-12 Thread WreckRman2
How can one get the next record to compare two fields... I want to check if the date of the first record matches the date of the next record with the least amount of code... David Smith Indy Web Design http://www.indywebdesign.com -- PHP General Mailing List (ht