Hi
I will explain what I am trying to do:
I have used MYPHP admin to create a database where user booking details will be stored in a table called bookings.
Now I need to retrieve all the bookings for a specific date. For achieving this I have created two pages one is html page for user to type the date and click on get bookings and the second page is a php page where it will have the database connection and the MySQL query.
But it only returns a blank page. Below are my html and php pages code.
Any help will be highly appreciated
Kind Regards
HB25
Html page
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Bookings Details </title>
</head>
<body>
<p>Enter the client and Booking date below to chek bookings information </p>
<form action="../actions/bookings_details.php" method="post">
<p><label for="date">Booking Date:</label><br />
<input id="%D %M %Y" name="%D %M %Y" type="text" /></p>
<p><input type="submit" value="check Booking" /></p>
</form>
</body>
</html>
PHP page
<html>
<head>
<title>Bookings Details</title>
</head>
<body>
<?php
$con = mysql_connect("xxxxxx","xxxxxxx","xxxxxx");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("xxxxxxxx", $con);
SELECT * FROM bookings WHERE startdate=$_POST[%D %M %Y];
mysql_close($con);
?>
</body>
</html