<?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>Manage Picture Assignment</h1>


<i><font color="#C11B17" size="0.5px">
Click <a href="admin_assignpicture.php" target="blank">here</a> make a new picture assignment.<br>
Click <a href="admin_uploadimage.php" target="blank">here</a> to upload a new picture.<br>
Click <a href="admin_addpackage.php" target="blank">here</a> to add a new package.<br><br></i></font>
<ul>



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

$dbh = mysql_connect(hostname, username, password)

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

mysql_select_db (dbname, $dbh);

$result = mysql_query("SELECT * FROM pictures
INNER
JOIN packages
ON packages.package_id=pictures.package_id
ORDER BY picturefile ASC");

// start a counter in order to number the input fields for each record
$i = 0;

// open a form
print "<form name='editpictureassignment' method='post' action='admin_pictureassignmentscript.php'>\n";

// start a loop to print all of the courses with their book information
// the mysql_fetch_array function puts each record into an array. each time it is called, it moves the array counter up until there are no more records left
while ($packageassignment = mysql_fetch_array($result)) {

print "<input type='hidden' name='picture_id[$i]' value='{$packageassignment['picture_id']}' />";
print "<table><tr><td width=\"400px\"><select><option size='50' type='text' name='package_name[$i]' value='{$packageassignment['package_name']}' />{$packageassignment['package_name']}</option></select></td>";
print "<td>{$packageassignment['picturefile']}<br><img width='182px' height='158px' src='pkgimg/{$packageassignment['picturefile']}'></td></tr></table><br><hr>";

// add 1 to the count, close the loop, close the form, and the mysql connection
++$i;
}
print "<br><input type='submit' value='submit' />";
print "</form>";
mysql_close();
?>






<br><br>




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


</div>

</body>

</html>