Re: Get next record
| From: | Christian Reiniger | Date: | Tue, 13 Mar 2001 09:56:52 +0000 |
| Subject: | Re: Get next record | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-43641@lists.php.net to get a copy of this message | ||
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