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