You should be able to do this at the database level - of course you never
said what database that is.
Regardless, check your database documentation for the max() and min()
functions - never used these on date but they might work - do you always
want the first record and the last record in the
Message-
From: Jason Vincent [mailto:jayv;nortelnetworks.com]
Sent: November 13, 2002 12:24 PM
To: Aaron Wolski; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Difference between 2 dates.. thoughts?
You should be able to do this at the database level - of course you
never
said what database
13, 2002 12:27 PM
To: Vincent, Jason [BRAM:1334:EXCH]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Difference between 2 dates.. thoughts?
Hi There,
Well the first and last record of the results.
So if 1000 records were found... then record #1 and then record #1000 -
perform data calculation between
]
Subject: RE: [PHP-DB] Difference between 2 dates.. thoughts?
Test whether min() and max() work on date fields - never tried it. Or
check the documentation on date and time functions for your database -
they may have something that does this.
If not, you could just do an order by date ascending