I'm struggling, please help

[jackiw]

Hi all,

I'm struggling trying to think in a way to do this:

I have two fields in a form, the Pickup Date and the Return Date. How can I do to, when the user selects the pickup date and the return date, check if the book is rented or not. The problem that I'm having is the gap between the dates. Lets say the book_1 is rented from Sep 10 2003 to Sep 12 2003. How would be the expression to check if the book is rented or not?

This is what I'm doing, and it's not working:

$que = mysql_query("Select * from rented where ID='1' and ($entered_pick > pickup and $entered_pick > return) and ($entered_drop > pickup and $entered_drop > return)");
if(mysql_num_rows($q_e)) {
print "<font color=red><b>Not available</b></font>";
} else {
print "<font color=red><b>Available</b></font>";
}

Thank you all.

[Norman_Graham]

Hi Jackiw

I'm not sure what you mean by 'book rented' - are you running a library?

Anyway, mysql_num_rows() returns a number. If there are no results, you get 0, otherwise you get a positive integer. What you need to do is this:

if (mysql_num_rows($query) == 0)
{
echo "Nothing doing";
}

else
{
$num = mysql_num_rows($query);
echo "There are " . $num . "possibilities.";
}

Having said that, you'll need to supply more details about the type of data in the fields 'pickup' and 'return' - is the data of a type that you can simply do maths equations with them. I suspect you need some MySQL date and time functions, but I'd need more info on your table.

HTH

Norm