[PHP] between date

Hi all 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. Kind Regards and thank you in advance Brent Clark -- PHP General Mailing List

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 |

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

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. [/snip] Use