Select where date is in period
| From: | boclair | Date: | Thu, 22 Mar 2001 06:04:46 +0000 |
| Subject: | Select where date is in period | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7685@lists.php.net to get a copy of this message | ||
The database has a table of equipments with date fields for
date_online and date_offline.
The requirement is to find which equipments were available on a date
specified by the user, this being a variable created by the user.
My attempts at scripting for the condition where the date_online <=
'specified variable' and the date_offline => 'specified variable'
totally fail for syntax says mySQL (and possibly for method)
I would be grateful for help or a pointer to a reference.
Tim Morris