<?

include("adminincludes/header.php");

// store info in session vars.

echo "<h2>Edit</h2> \n";

//Output data: Out put ALL records so that we can build some sort of nav system to allow user choose which one to edit.
$result = mysql_query("SELECT * FROM cd_collection");
while ($row = mysql_fetch_array($result)){

	//Create some php variables that store each piece of info that we need.

	$id = $row['id'];
	$artist = $row['artist'];
	//echo $id . "|";
	//Dynamically build links that user can select a single record form.
	$thisPage = "edit.php?id=$id";
	$thisLink = "<a href=\"$thisPage\">$artist</a> | \n";
	echo $thisLink;

}

echo "<hr />";
//get the GET var that stores the id of the record that we want to edit.

if(isset($_GET['id'])){
$id = $_GET['id'];
}else{
$id=1; //if no ID passed to this page, assume the first record.
}

//Output data. Only one specific record we want to edit.
$result = mysql_query("SELECT * FROM cd_collection WHERE id=$id");
while ($row = mysql_fetch_array($result)){
	//Create some php variables that store each piece of info that we need.
	$artist = $row['artist'];
	$title = $row['title'];
	$year = $row['year'];
	$genre = $row['genre'];
	$artwork = $row['artwork'];
	$label = $row['label'];
	$description = $row['description'];

}
//Detect if user has pressed submit button.Get new content from the form; put that into the database.
if(isset($_POST['submit'])){
$artist = $_POST['artist'];
$title = $_POST['title'];
$year = $_POST['year'];
$genre = $_POST['genre'];
$artwork = $_POST['artwork'];
$label = $_POST['label'];
$description = $_POST['description'];

//Update the DB with the new data
if($artwork!=""){
$sql = "UPDATE cd_collection SET
artist = \"$artist\",
title = \"$title\",
year = \"$year\",
genre = \"$genre\",
$artwork = \"$artwork\",
label = \"$label\",
description = \"$description\"
WHERE id=$id";
}else{
$sql = "UPDATE cd_collection SET
artist = \"$artist\",
title = \"$title\",
year = \"$year\",
genre = \"$genre\",
label = \"$label\",
description = \"$description\"
WHERE id=$id";
}

$result = mysql_query($sql) or die (mysql_error());
}
?>

<form enctype="multipart/form-data" action='<?echo $_SERVER['PHP_SELF']; echo "?id=$id" ?>' method='post'/>
<label for='artist'>Artist: </label><input type='text' name='artist' id='artist' value='<?echo $artist;?>' minlength='4' maxlength='20' /><br/>
<label for='title'>Title: </label><input type='text' name='title' id='title' value='<?echo $title;?>'/><br/>
<label for='year'>Year: </label><select name="year">
<? echo "<option selected=\"selected\">$year</option>\n"; ?>
<option value="2008">2008</option>
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="1981">1981</option>
<option value="1980">1980</option>
<option value="1979">1979</option>
<option value="1978">1978</option>
<option value="1977">1977</option>
<option value="1976">1976</option>
<option value="1975">1975</option>
<option value="1974">1974</option>
<option value="1973">1973</option>
<option value="1972">1972</option>
<option value="1971">1971</option>
<option value="1970">1970</option>
<option value="1969">1969</option>
<option value="1968">1968</option>
<option value="1967">1967</option>
<option value="1966">1966</option>
<option value="1965">1965</option>
<option value="1964">1964</option>
<option value="1963">1963</option>
<option value="1962">1962</option>
<option value="1961">1961</option>
<option value="1960">1960</option>
<option value="1959">1959</option>
<option value="1958">1958</option>
<option value="1957">1957</option>
<option value="1956">1956</option>
<option value="1955">1955</option>
<option value="1954">1954</option>
<option value="1953">1953</option>
<option value="1952">1952</option>
<option value="1951">1951</option>
<option value="1950">1950</option>
<option value="1949">1949</option>
<option value="1948">1948</option>
<option value="1947">1947</option>
<option value="1946">1946</option>
<option value="1945">1945</option>
<option value="1944">1944</option>
<option value="1943">1943</option>
<option value="1942">1942</option>
<option value="1941">1941</option>
<option value="1940">1940</option>
<option value="1939">1939</option>
<option value="1938">1938</option>
<option value="1937">1937</option>
<option value="1936">1936</option>
<option value="1935">1935</option>
<option value="1934">1934</option>
<option value="1933">1933</option>
<option value="1932">1932</option>
<option value="1931">1931</option>
<option value="1930">1930</option>
<option value="1929">1929</option>
<option value="1928">1928</option>
<option value="1927">1927</option>
<option value="1926">1926</option>
<option value="1925">1925</option>
<option value="1924">1924</option>
<option value="1923">1923</option>
<option value="1922">1922</option>
<option value="1921">1921</option>
<option value="1920">1920</option>
<option value="1919">1919</option>
<option value="1918">1918</option>
<option value="1917">1917</option>
<option value="1916">1916</option>
<option value="1915">1915</option>
<option value="1914">1914</option>
<option value="1913">1913</option>
<option value="1912">1912</option>
<option value="1911">1911</option>
<option value="1910">1910</option>
<option value="1909">1909</option>
<option value="1908">1908</option>
<option value="1907">1907</option>
<option value="1906">1906</option>
<option value="1905">1905</option>
<option value="1904">1904</option>
<option value="1903">1903</option>
<option value="1902">1902</option>
<option value="1901">1901</option>
<option value="1900">1900</option>
</select><br/>
<label for='genre'>Genre: </label><input type='text' name='genre' id='genre' value='<?echo $genre;?>'/><br/>
<label for='artwork'>Album Cover: </label><input type="hidden" name="MAX_FILE_SIZE" value="300000" /><input type="File" id="artwork" name="artwork"><?php echo "<img src=\"../artwork/thumbs100/$artwork\" />"?><br/>
<label for='label'>Label: </label><input type='text' name='label' id='label' value='<?echo $title;?>'/><br/>
<label for='description'>Description: </label><textarea name='description' id='description'><?echo $description;?></textarea><br/>
<input type='submit' name='submit' id='submit' value='Update CD' />
</form>

<?php

//Create a link to the delete page.
echo "<p><a href=\"delete.php?id=$id\">Delete this Character</a></p>";

include("adminincludes/footer.php");
?>