include "../db.php4"; if (isset($title)) { $SQL = "UPDATE wine SET boxnum = $boxnum, cdnum = $cdnum, title = '$title', drunk = '$drunk', nose = $nose, palate = $palate, finish = $finish, drunkdate = '$drunkdate', rack = '$rack', drink = '$flagdate', winery = '$winery', year = '$year', region = '$region', grape = '$grape' WHERE CDID = $CDID;"; //print($SQL); @mysql_query($SQL); @mysql_close($dbcnx); header("Location: $DS_REFERER"); } $rs = @mysql_query("SELECT *, UNIX_TIMESTAMP(drunkdate) as unixdrunkdate FROM wine WHERE CDID = $CDID;"); $row = @mysql_fetch_array($rs); ?>
Update Wine:
@mysql_close($dbcnx); ?>