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.id = $TheRecordYouWant) AND (First.DateField = Second.DateField)
?
--
Christian Reiniger
LGDC Webmaster (http://sunsite.dk/lgdc/)
I sat laughing snidely into my notebook until they showed me a PC running
Linux. And oh! It was as though the heavens opened and God handed down a
client-side OS so beautiful, so graceful, and so elegant that a million
Microsoft developers couldn't have invented it even if they had a hundred
years and a thousand crates of Jolt cola.
- LAN Times
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]