<?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" />



</head>


<?php include 'admin_header.php'; ?>

<h1>Add a new Price Package</h1>



 <form method="post" action="admin_addpricescript.php">

 <select name="package_id"  />  <option disabled="disabled" selected="selected">Select a package:</option> 
 <?php

require_once('connectvars.php');

	

$dbh = mysql_connect(hostname, username, password)

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

mysql_select_db (dbname, $dbh);



$query = sprintf("SELECT package_name, package_id FROM packages ORDER BY package_name ASC");




$result = mysql_query($query);


if (!$result) {

    $message  = 'Invalid query: ' . mysql_error() . "\n";

    $message .= 'Whole query: ' . $query;

    die($message);

}


while ($row = mysql_fetch_assoc($result)) {


echo "<option value=\"".$row['package_id']."\">".$row['package_name']." - ID: ".$row['package_id']."</option>";

}
?>
</select><br><br>

<strong>Rating: </strong> <input size="1" type="text" name="rating"  /><i><font color="#C11B17" size="0.5px">Not needed for Price Layout 1 (Layout 1: price packages with different hotel ratings in each. Layout 2: pricing based on a star rating.</font><br><br>
<strong>Season: </strong> <input size="50" type="text" name="season"  /> <i><font color="#C11B17" size="0.5px">Enter 'Year Round' or specific date info if applicable.</font><br><br>
<strong>Triple Occupancy Cost: </strong><input type="text" name="triplecost"  />  <i><font color="#C11B17" size="0.5px">$X,XXX</font><br><br>
<strong>Double Occupancy Cost: </strong><input type="text" name="doublecost"  />   <i><font color="#C11B17" size="0.5px">$X,XXX</font><br><br>
<strong>Single Occupancy Cost: </strong><input type="text" name="singlecost"  /> <i><font color="#C11B17" size="0.5px">$X,XXX</font><br><br>
<strong>Minor Cost: </strong><input type="text" name="minorcost"  />  <i><font color="#C11B17" size="0.5px">$X,XXX</font><br><br>

<input type="submit" value="Submit">
</form>
  



</div>

</body>

</html>