To start with the user can choose two seats one from each drop down box
Code: Select all
//DROP DOWN BOX ONE
$extract =mysql_query("SELECT * FROM ride WHERE rideID ='1'");
$numrows = mysql_num_rows($extract);
//start of form
echo '<form method="post" name="f1" action="card.php">';
echo 'Please choose a seat: ';
echo"<select name='seat' >";
while( $row = mysql_fetch_assoc($extract))
{
$rideID = $row ['rideID'];
$name = $row ['name'];
$seatNumber = $row ['seatNumber'];
$time = $row ['time'];
$price = $row ['price'];
echo "<option name='seat'> $seatNumber </option>";
$_SESSION['extract']=$_POST['seat'];
}
echo '</select><br>';
//DROP DOWN BOX TWO
$extract2 =mysql_query("SELECT * FROM ride WHERE rideID ='1'");
$numrows = mysql_num_rows($extract2);
//start of form
echo '<form method="post" name="f2" action="card.php">';
echo 'Please choose a seat: ';
echo"<select name='seat2' >";
while( $row = mysql_fetch_assoc($extract2))
{
$rideID = $row ['rideID'];
$rideName = $row ['rideName'];
$seatNumber = $row ['seatNumber'];
$time = $row ['time'];
$price = $row ['price'];
echo "<option name='seat2'> $seatNumber </option>";
$_SESSION['extract2']=$_POST['seat2'];
}
echo '</select><br>';
Code: Select all
$query =mysql_query("SELECT price FROM ride WHERE rideID ='1' LIMIT 1");
while ($row=mysql_fetch_array($query))
{
echo $row['price'];
echo "<br>";
$seatPrice1=($row['price']);
$seatPrice2=($row['price']*2);
$vat1=17.5;
function vat($vat, $row['price'])
{
return sprintf("%01.2f", ($vat*$row['price]/ 100));
}
$vatprice = vat(17.5, 2.50);
$total1=($vatprice);
$total2=($vatprice*2);
$endPrice1= ($total1+$seatPrice1);
$endPrice2= ($total2+$seatPrice2);
What I need is $endPrice1 and $endPrice2 in $_SESSIONS so i an INSERT them in to the database 3 pages away from this query/VAT fucntion.
A look at the syntax and structure of the query would be a great help too =)
Can anyone help? Thanks.