session_start();
include("inc/db.php");
include("inc/login.php");
include("inc/datediff.php");
$db = new dbconn();
$db->connect();
?>
DVD Collection - Edit DVD
if ($logged_in) {
if ($_REQUEST['Action'] == "edit") {
$ures = mysql_fetch_assoc(mysql_query("SELECT ID FROM users WHERE username='".$_SESSION['username']."'"));
$userID = $ures['ID'];
$strSQL = mysql_query("SELECT * FROM DVDcollection WHERE DVDID=".$_REQUEST['DVD']." AND UserID=".$userID);
while ($rsDVD = mysql_fetch_assoc($strSQL)) {
$Title = trim($rsDVD['Title']);
$IMDBURL = trim($_REQUEST['IMDBURL']);
$PictureURL = trim($_REQUEST['PictureURL']);
$CoverURL = trim($_REQUEST['CoverURL']);
$Audio = trim($_REQUEST['Audio']);
$Subtitles = trim($_REQUEST['Subtitles']);
$AspectRatio = trim($_REQUEST['AspectRatio']);
$Extras = trim($_REQUEST['Extras']);
?>
}
} else {
$ures = mysql_fetch_assoc(mysql_query("SELECT ID FROM users WHERE username='".$_SESSION['username']."'"));
$userID = $ures['ID'];
$Title = $_REQUEST['Title'];
$IMDBURL = $_REQUEST['IMDBURL'];
$PictureURL = $_REQUEST['PictureURL'];
$CoverExt = $_REQUEST['CoverExt'];
$Audio = $_REQUEST['Audio'];
$Subtitles = $_REQUEST['Subtitles'];
$AspectRatio = $_REQUEST['AspectRatio'];
$Extras = $_REQUEST['Extras'];
$IMDBRating = $_REQUEST['IMDBRating'];
$strSQL = "UPDATE DVDcollection SET Title='".$Title."', IMDBURL='".$IMDBURL."', PictureURL='".$PictureURL."', CoverExt='".$CoverExt."', Audio='".$Audio."', Subtitles='".$Subtitles."', AspectRatio='".$AspectRatio."', Extras='".$Extras."', IMDBRating='".$IMDBRating."' WHERE DVDID=".$_REQUEST['DVD']." AND UserID=".$userID;
mysql_query($strSQL);
echo "DVD \"".$Title."\" successfully updated
";
echo "Add a DVD
";
echo "Return to listing";
}
}
?>