Re: [PHP] between date

>"Jay Blanchard" <[EMAIL PROTECTED]> wrote in message ews:[EMAIL PROTECTED] >[snip] >I have a table whereby I use the php date() and time() function. > >I retrieve the data etc, no problem. > >but I now need to perform a query of between dates. > >Is there a function or method to perform this. >[/

RE: [PHP] between date

[snip] I have a table whereby I use the php date() and time() function. I retrieve the data etc, no problem. but I now need to perform a query of between dates. Is there a function or method to perform this. [/snip] Use SQL 'BETWEEN' i.e. SELECT items FROM table WHERE date BETWEEN this date A

Re: [PHP] between date

Hi Sorry, I should have copied and pasted the table structure before, sending the mail. (Sorry for the scewness) Kind Regards Brent Clark ++---+++++ | id | user | ref_id | stage | files_captured | time | ++---+