___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.
Still searching for a solution
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]
