Untitled

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>entries</title>
</head>

<body>


<?php

Include('mysql_db_connection.php');

$name = $_POST['name'];
$artist = $_POST['artist'];
$year = $_POST['year'];

$add = "INSERT INTO albums (id, name, artist, year) VALUES
(0, '$name', '$artist', '$year')";


if (@mysql_query($add, $dbc)) {
	print '<p>'. $name . ' by ' . $artist . ' has been added! </p>';
	}

	else {
	print '<p style="color: red;">Could not add the entry because:<br />' .
	mysql_error($dbc) . '.</p><p>The query being run was: ' . $add . '</p>';
}


$select = 'SELECT * FROM albums ORDER BY artist';

if ($r = mysql_query($select, $dbc)) {

	while ($row = mysql_fetch_array($r))

	{

        $listing =
		"<form action='{$_SERVER['PHP_SELF']}' method='post'>
         <ul>
			<li>{$row['id']}</li>
			<li><input type='text' name='name' size='20' maxsize='20' value = '{$row['name']}'/></li>
			<li><input type='text' name='artist' size='20' maxsize='20' value = '{$row['artist']}'/></li>
			<li><input type='text' name='year' size='20' maxsize='20' value = '{$row['year']}'/></li>
		 </ul>
		<input type='submit' name='submit' value='Post This Entry!' />
		</form>";
		echo ($listing);
	}

	} else {
		print '<p style="color: red;">Could not retrieve the data because:<br />' . mysql_error($dbc)
		. '.</p><p>The query being run was: ' . $select . '</p>';
}

mysql_close($dbc);

?>

<h1>entries</h1>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
	<p>Entry Album Name: <input type="text" name="name" size="20" maxsize="20" /></p>
	<p>Entry Artist: <input type="text" name="artist" size="20" maxsize="20" /></p>
	<p>Entry Year: <input type="text" name="year" size="4" maxsize="4" /></p>
	<input type="submit" name="submit" value="Post This Entry!" />
</form>


</body>
</html>