<?php 
// --------------------------------------------------------------------------------
include("../dbinfo.php");
$linkid = mysql_connect($hostname,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");   // @
// Base query 
$query ='';
$query = "SELECT * FROM $CarsTable";  
$result = @mysql_query($query,$linkid);

$count = @mysql_num_rows($result);
echo "  ( Your query returned " . $count . " items. )";
?>

<?php require_once('results.php'); 
			session_start();
			$_SESSION['readybooking']="yes";
	  mysql_free_result($result);
	  mysql_close($linkid); ?>

<style type="text/css">
<!--
.style12 {color: #000000}
.style14 {color: #006699}
.style15 {color: #006600}
-->
</style>
<?
// $type
$i=0;
	if ($count > 0) {
             while ($i < $count) {
			    $cat = mysql_result($result,$i,"cat");
				$model = mysql_result($result,$i,"model");
				$type = mysql_result($result,$i,"type");
				$transm = mysql_result($result,$i,"transm");
				$cc = mysql_result($result,$i,"cc");
				$fuel = mysql_result($result,$i,"fuel");
				$doors = mysql_result($result,$i,"doors");
				$people = mysql_result($result,$i,"people");
				$suitcases = mysql_result($result,$i,"suitcases");
				$description = mysql_result($result,$i,"description");
				$availability = mysql_result($result,$i,"availability");
				$img_small = mysql_result($result,$i,"img_small");
				$img_big = mysql_result($result,$i,"img_big");
				$special_offer = mysql_result($result,$i,"special_offer");
				$discount = mysql_result($result,$i,"discount");
				$notes = mysql_result($result,$i,"notes");
?>
<tr><td><fieldset><legend><?= $type ?></legend><table width="580" border="0" cellpadding="5" cellspacing="0" class="menutext" summary="quote result table cell">
  <tr>
    <td width="132" rowspan="2">&nbsp;</td>
    <td width="298">&nbsp;</td>
    <td width="120">&nbsp;</td>
  </tr>
  <tr>
    <td rowspan="3" align="center" valign="middle"><table width="104%"  border="0" cellpadding="1" cellspacing="0" class="menutext" summary="characteristics table of car for rent">
      <tr>
        <td width="32%" align="left" valign="middle" class="style14"><span class="style4"> model </span></td>
        <td width="68%" align="left" valign="middle"><span class="style2">
          <?= $model ?>
        </span></td>
      </tr>
      <tr>
        <td align="left" valign="middle" class="style14"><span class="style4">people/door</span></td>
        <td align="left" valign="middle"><span class="style2">
          <?= $people ?>
          &nbsp;/&nbsp;
          <?= $doors ?>
</span></td>
      </tr>
      <tr>
        <td align="left" valign="middle" class="style14"><span class="style4"> trans </span></td>
        <td align="left" valign="middle"><span class="style2">
          <?= $transm ?>
        </span></td>
      </tr>
      <tr>
        <td align="left" valign="middle" class="style14"><span class="style4"> size/fuel</span></td>
        <td align="left" valign="middle"><span class="style2">
          <?= $cc ?>cc
&nbsp;/&nbsp;
<?= $fuel ?>
</span></td>
      </tr>
      <tr>
        <td align="left" valign="middle" class="style14"><span class="style4"> luggage </span></td>
        <td align="left" valign="middle"><span class="style2">
          <?= $suitcases ?>
        </span></td>
      </tr>
      <tr>
        <td align="left" valign="middle" class="style14"><span class="style4"> status </span></td>
        <td align="left" valign="middle"><span class="style2">
        <?= $availability ?>
</span></td>
      </tr>
      <tr>
        <td class="style14">&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
    </table></td>
    <td rowspan="2" align="center" valign="middle"><p>&nbsp;<span class="text_normal20pxbold">€<?= $mostdaysrate[$i+1]; ?></span>/day
          </p>
      <p><span class="style14">&nbsp;total&nbsp;€<?= $finalprice[$i+1]; ?><br>
      </span>&nbsp;<span class="style15">save&nbsp;€<?= $off[$i+1]; ?>&nbsp;&nbsp;20% OFF
        </span></p>      </td>
  </tr>
  <tr>
    <td height="38" align="center" valign="middle"><img src="<?= $img_small ?>" alt="<?= $model ?>" border="1" /></td>
    </tr>
  <tr>
    <td height="65" align="center" valign="middle"><p>Group&nbsp;
          <?= $cat ?>
    </p>
      <p>
        <?= $description ?>  
        </p></td>
    <td align="center" valign="middle"><form action="../customeradmin/booking-review.php" method="post" enctype="application/x-www-form-urlencoded" name="<?= "form".$i ?>" target="_self">
    		  <input type="hidden" name="datep" value="<?= $datep ?>" />            
			  <input type="hidden" name="dated" value="<?= $dated ?>" />
            <input type="hidden" name="Locationp" value="<?= $Locationp ?>" />
            <input type="hidden" name="Locationd" value="<?= $Locationd ?>" />
            <input type="hidden" name="days" value="<?= $days ?>" />
            <input type="hidden" name="mostdaysrate" value="<?= $mostdaysrate[$i+1] ?>" />
            <input type="hidden" name="off" value="<?= $off[$i+1] ?>" />
            <input type="hidden" name="vat" value="<?= $vat[$i+1] ?>" />
            <input type="hidden" name="cat" value="<?= $cat ?>" />
            <input type="hidden" name="finalprice" value="<?= $finalprice[$i+1] ?>" />
            <input type="hidden" name="car" value="<?= "Group ".$cat."-".$model ?>" />
<a href="<?= "javascript:form".$i.".submit()" ?>"><img src="../images/but_bookit.gif" width="80" height="22" border="0"></a>
    </form></td>
  </tr>
</table>
</fieldset>		
		</td></tr>
		<tr><td><hr size="3" /></td></tr>
<?
++$i;
             } # end while
	} else {  ?>
<table>
  <tr>
    <td class="p  style2">No results found. Please try again! </td>
  </tr>
</table>
<?
	} 
?>