"boclair" <[EMAIL PROTECTED]> wrote in message
005101c0b2d2$4e6b3920$[EMAIL PROTECTED]">news:005101c0b2d2$4e6b3920$[EMAIL PROTECTED]...
|
| ----- Original Message -----
| From: boclair <[EMAIL PROTECTED]>
| To: <[EMAIL PROTECTED]>
| Sent: Thursday, March 22, 2001 10:45 PM
| Subject: Re: [PHP-DB] Select where date is in period
|
|
| >
| > ___Morris___
| >
| > 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)
| >
| > ___Richard___
| >
| > Have you checked at the BETWEEN (x and y) clause?
| >
| > e.g.
| >
| > SELECT * FROM table WHERE searchdate BETWEEN (date_online
AND
| > date_offline)
| >
| > Not tested this on MySQL, but the above is perfectly legal SQL92.
| >
| > ___Morris_____
| >
| > Thanks for that. I searched the Manual, yet again and could not
| find
| > this or like syntax. I tried it though and got
| > Warning: Supplied argument is not a valid MySQL result resource.
| >
| > My attempt, one of many,
| >
| > $result = mysql_query("select * from plant.eqpt where date_online
<=
| > $checkdate AND where date_offline => $checkdate order by type,
| > size");
| >
| > generated the same warning.
|
| ________
|
| Please check this solution for syntax and method. MySQL didn't give
| errors or warnings and results were as required.
|
| $result = mysql_query("select * from plant.eqpt where date_online <=
| $checkdate && $checkdate <= date_offline order by type, size");
|
| or can use AND in lieu of &&
|
| or can place where conditions in brackets as
|
| where (date_online <= $checkdate && $checkdate <= date_offline)
Sorry. Careless as usual. The variable $checkdate was enclosed in
single quotes as
$result = mysql_query("select * from plant.eqpt where date_online <=
'$checkdate' && '$checkdate' <= date_offline order by type, size");
Tim Morris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
