>"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 SQL 'BETWEEN' i.e. > >SELECT items FROM table WHERE date BETWEEN this date AND that date > >It is inclusive
I think working with >= and <= works as well and may be more portable: SELECT items FROM table WHERE date >= start AND date <= end Regards, Torsten -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
