Untitled

<html>
<head>

<title>movies library home page</title>

</head>
<body>
<h1>movies</h1>
<?php

$con=mysql_connect("mysql.ict.valley.outwood.com","oavcs62","zimf-stZ");
$db_found = mysql_select_db("oavcs62");
$result = mysql_query("Select movieID, Genre, Title, Description, RentalPrice FROM movies");

echo "<table>
	<tr>
		<th>Movie ID</th>
		<th>Genre</th>
		<th>Movie Name</th>
		<th>Movie Description</th>
		<th>Rental Cost Per Day</th>
	</tr>";

while($row = mysql_fetch_array($result))
{
	echo "<tr>";
	echo "<td>" . $row['MovieID'] . "</td>";
	echo "<td>" . $row['Genre'] . "</td>";
	echo "<td>" . $row['Title'] . "</td>";
	echo "<td>" . $row['Description'] . "</td>";
	echo "<td>" . $row['RentalPrice'] . "</td>";

echo "</tr>";
}

echo"</table>";
mysql_close($con);

?>
<br /><br />
</body>
</html>