Yeah sure
This is the 1st file, where you select the dates.
session_start();
echo '<form action="javascript://" onsubmit="window.open(\'check.php?checkday='.$checkday.'&checkmonth='.$checkmonth.'&checkyear='.$checkyear.'\', \'winname\', \'width=300,height=100,scrollbars=no,menubar=no,location=no,status=no,resizable=no,toolbars=no\');" method="POST">';
echo '<div align="center">
<select name="checkday" value="'. $checkday .'">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="checkmonth" value="'. $checkmonth .'">
<option value="01">January</option>
<option value="02">February</option>
<option value="03">March</option>
<option value="04">April</option>
<option value="05">May</option>
<option value="06">June</option>
<option value="07">July</option>
<option value="08">August</option>
<option value="09">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
<select name="checkyear" value="'. $checkyear .'">
<option value="2001">2001</option>
<option value="2002">2002</option>
<option value="2003">2003</option>
<option value="2004">2004</option>
</select>
<br>
<input type="submit" name="check" value="Check Availability">
</div>
</form>';
And this is the 2nd file (the popup) that runs the query on the database.
session_start();
$sql="SELECT * from restaurant_availability WHERE date='$checkdate' && month='$checkmonth' && year='$checkyear'";
global $feedback;
$result=mysql_query($sql);
if(db_numrows($result) > 0){
$feedback .= ' We\'re sorry, The restuarant is fully booked on that date, You should have booked sooner! ';
} else {
$feedback .= ' Congratulations, we are availability on that date ';
}
if ($feedback) {
echo '<div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" FONT COLOR="RED"><H5>'.$feedback.'</H5></FONT></div>';
}
If i enter the url of this file in manually, with the varialble, like..
check.php?checkday=12&checkmonth=12&checkyear=2001
It works fine, its just trying to parse the variables to this file!
Many Thanks for your help
Ben