Thanks for everyones help yesterday but nI have come up against a problem
(as I am new). I have created my document as detailed below with notes. I
can see from the form that I have connected to the server, accessed the
correct database, created the statment and executed it. The problem is how
to display the information - as far as I can understand from yesterday if
the result is 0 then the villa is available. So what I need to do is if the
result = 0 display villa available and if the result is greater than 0 then
display villa not available . I know that the variables are getting to the
query as if I change the echo $result; to $sql; and key in 3 as the id and
2 dates in the form I get the following:
SELECT COUNT(*) FROM bookings WHERE ('2002-04-04') BETWEEN booking_start AND
booking_end OR ('2002-04-10')BETWEEN booking_start AND booking_end AND
villa_id = ('3')
So, corrcet me if I am wrong but the query is working its just i cannot see
anything. I have spent hours on this today, reading books and looking at the
list. I hope that once I have done one good script I can then start to
understand it and create more :-)
Thanks for all your help
Ray
<html>
<body>
<?php
if ($submit) {
// open connection to database
$db = mysql_connect("localhost", "matrix", "matrix");
// pick database to use
mysql_select_db("matrix",$db);
// create the SQL statement
$sql = "SELECT COUNT(*) FROM bookings WHERE ('$book_start_date') BETWEEN
booking_start AND booking_end OR ('$book_end_date')BETWEEN booking_start AND
booking_end AND villa_id = ('$place')";
// execute the SQL statement
$result = mysql_query($sql);
// display the information
echo $result;
} else{
// display form
?>
<form method="post" action="<?php echo $PHP_SELF?>">
Villa id number:<input type="Text" name="place"><br>
Start date:<input type="Text" name="book_start_date"><br>
End date:<input type="Text" name="book_end_date"><br>
<input type="Submit" name="submit" value="Search information">
</form>
<?php
}
// end if
?>
</body>
</html>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
