Hi
Sorry for the trouble
here's what i came up actually
<?php
require_once('auth.php');
require_once('config.php');
require_once('calendar/classes/tc_calendar.php');
header ( "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0");
header ("Pragma: no-cache");
$id=$_GET['id'];
$vehicle=$_POST['vehicle'];
$category=$_POST['category'];
$price=$_POST['price'];
$loading=$_POST['loading'];
$landing=$_POST['landing'];
$veh=$_POST['veh'];
$cat=$_POST['cat'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1" http-equiv="content-type">
<title><?php echo $title; ?></title>
<script language="javascript" src="calendar/calendar.js"></script>
<link href="calendar/calendar.css" rel="stylesheet" type="text/css">
<link href="loginmodule.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="header"><div><img src="images/lfc_logo.gif" alt="" border="0" class="logo" /></div></div>
<?php include('nav.php'); ?>
<div id="welcome"><h1>Welcome <?php echo $_SESSION['SESS_FIRST_NAME'];?></h1></div>
<div id="container">
<?php include('menu_vehicle.php'); ?>
<div id="content">
<h1>Edit Ticket No. <?php echo $id; ?></h1>
<?php
mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)or die("cannot connect");
mysql_select_db(DB_DATABASE)or die("cannot select DB");
$q1 = "SELECT * FROM issueveh WHERE id='$id'";
$r1 = mysql_query($q1) or die (mysql_error());
while($rw1 = mysql_fetch_array($r1)) {
?>
<table width="100%" border="0" cellpadding="0" cellspacing="1">
<form name="form1" id="form1" method="post" action="vehicle_updateplateno1.php?id=<? echo $id; ?>">
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td width="15%">Ticket No :</td>
<td width="30%"><input name="id" type="hidden" id="id" class="required" value="<?php echo $rw1['id']; ?>"><?php echo $rw1['id']; ?>
</td>
</tr>
<tr>
<td width="15%">Plate No :</td>
<td width="30%"><input name="plateno" type="hidden" id="plateno" class="required" value="<?php echo $rw1['plateno']; ?>"><?php echo $rw1['plateno']; ?></td>
<td width="15%">Landing :</td>
<td width="30%"><input name="landing" type="hidden" id="landing" class="required" value="<?php echo $landing; ?>">RM <?php echo $landing; ?></td>
</tr>
<tr>
<td width="15%">Price :</td>
<td width="30%"><input name="price" type="hidden" id="price" class="required" value="<?php echo $rw1['price']; ?>">RM <?php echo $rw1['price'] ?></td>
<td width="15%">Loading :</td>
<td width="30%"><input name="loading" type="hidden" id="loading" class="required" value="<?php echo $loading; ?>">
<?php
$q5 = "SELECT * FROM vehicle where category='$CAT'";
$r5 = mysql_query($q5);
$rw5=mysql_fetch_array($r5); {
if ($loading == "noload") {
echo "No Load";
$ticketprice = $rw5['unload'];
echo $ticketprice;
} else if ($loading == "wload") {
$ticketprice = $rw5['wload'];
echo "With Load";
echo $ticketprice;
}
}
?></td>
</tr>
<tr>
<td width="15%">Vehicle :</td>
<td width="30%">
<select id="vehicle" name="vehicle" class="required">
<option value=""></option>
<?php
echo "<option selected value=\"". $vehicle . "\">" . $vehicle . "</option>";
$q2 = "SELECT * FROM vehicle WHERE vehicle NOT IN ('$vehicle')";
$r2 = mysql_query($q2) or die ("Error reading from database");
while($rw2=mysql_fetch_array($r2)) {
echo "<option value=\"". $rw2['vehicle'] . "\">" . $rw2['vehicle'] . "</option>";
}
?>
</select>
</td>
<td width="15%">Category :</td>
<td width="40%">
<select id="category" name="category" class="required">
<option value=""></option>
<?php
$q3 = "SELECT * FROM vehicle WHERE vehicle='$vehicle'";
$r3 = mysql_query($q3) or die ("Error reading from database");
while($rw3=mysql_fetch_array($r3)) {
$CAT = $rw3['category'];
}
echo "<option selected value=\"". $CAT . "\">" . $CAT . "</option>";
$q4 = "SELECT DISTINCT category FROM vehicle WHERE category NOT IN ('$CAT')";
$r4 = mysql_query($q4) or die ("Error reading from database");
while($rw4=mysql_fetch_array($r4)) {
echo "<option value=\"". $rw4['category'] . "\">" . $rw4['category'] . "</option>";
}
?>
</select>
<?php
echo $vehicle;
echo $veh;
echo $CAT;
echo $cat;
if ($CAT == $cat) {
echo "Category is the same";
echo "<br>";
echo "Price for Ticket No" .$rw1['id']." is RM " .$price. "";
$newprice = $price * 0.5;
echo "new price is" .$newprice. "";
} else if ($CAT == $CAT) {
echo "Category is different";
echo "<br>";
echo "Price for Ticket No" .$rw1['id']." is RM " .$newprice3. "";
}
if ($ticketprice > $price) {
$newprice1 = $ticketprice - $price;
} else if ($ticketprice < $price) {
$newprice1 = $price - $ticketprice;
}
$newprice2 = $ticketprice * 0.5;
$newprice3 = $newprice2 + $newprice1;
?>
</td>
</tr>
<tr>
<td> </td>
<td>
<input name="idtrip" type="hidden" id="idtrip" class="required" value="<?php echo $idtrip; ?>">
<input class="submit" type="submit" name="Submit" value="Submit">
<input type=button name=backButton id=backButton value="Back" onclick="javascript:history.go(-1)">
</td>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<?php
}
ob_flush();
?>
</div>
</div>
</body>
</html>
