Selecting from a Range of Dates

[TreacherousDog]

Hi,

I'm working on a check in / check out system that deals with a pool of computers. Basically we have a table containing the computers and a table containing reservations that links to the computers ID from another table.

My problem is I want to be able to allow my user to select a start date and an end date and have a query that can sort through the reservations to determine which units are not reserved inbetween those two dates.

I know I could easily do it in php by running a loop that runs a query for each day, but I was wondering if there is a better way to do it in a SQL query.

[devinemke]

a very basic example:

<form action="<? echo $_SERVER['PHP_SELF'] ?>" method="POST">
start date: <input type="text" name="start_date"> (YYY-MM-DD)<br>
end date: <input type="text" name="end_date"> (YYY-MM-DD)<br>
<input type="submit" name="submit" value="submit">
</form>

<?
if (isset($_POST['submit']))
{
	$sql = "SELECT * FROM table WHERE date_reserved NOT BETWEEN '" . $_POST['start_date'] . "' AND '" . $_POST['end_date'] . "'";
	echo $sql;
}
?>