<?php
	require_once ('authorize1.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-US">

<head>
<title>Moreno Travel</title>
<script src="sorttable.js"></script>
    <link href="style.css" rel="stylesheet" type="text/css" />
    <meta http-equiv="content-type"
        content="text/html; charset=utf-8" />

<style>

tr.order { border-bottom: 1px solid }</style

</head>


<?php include 'admin_header.php'; ?>
<h1>Moreno Travel Admin Portal</h1>


<ul>



<p>Thank you for updating.</p>



<?php
require_once('connectvars.php');

$dbh = mysql_connect(hostname, username, password)

	or die("Unable to connect to MySQL");

mysql_select_db (dbname, $dbh);

$size = count($_POST['price_id']);
//die($_POST['price_id'][0]);
$i = 0;

while ($i < $size) {


$price_id= $_POST['price_id'][$i];
//die($price_id);
$package_id= $_POST['package_id'][$i];
$rating = $_POST['rating'][$i];
$season= $_POST['season'][$i];
$triplecost= $_POST['triplecost'][$i];
$doublecost= $_POST['doublecost'][$i];
$singlecost= $_POST['singlecost'][$i];
$minorcost= $_POST['minorcost'][$i];

$query = "UPDATE prices SET `rating` = '$rating', `rating` = '$rating', `season` = '$season', `triplecost` = '$triplecost', `doublecost` = '$doublecost', `singlecost` = '$singlecost', `minorcost` = '$minorcost' WHERE `price_id` = '$price_id' LIMIT 1";
//die($query);
mysql_query($query) or die ("Error in query: $query");
++$i;
}
mysql_close();
?>




<br><br>




</ul><br><br><br>
</div>


</div>

</body>

</html>