include "../db.php4"; if (isset($title)) { @mysql_query("INSERT INTO cds SET boxnum = $boxnum, cdnum = $cdnum, title = '$title';"); //@mysql_close($dbcnx); //header("Location: index.php4"); } $rs = @mysql_query("SELECT MAX(boxnum) AS maxbox FROM cds;"); $row = @mysql_fetch_array($rs); $maxbox = $row["maxbox"]; $rs = @mysql_query("SELECT MAX(cdnum) AS maxcd FROM cds WHERE boxnum = $maxbox;"); $row = @mysql_fetch_array($rs); $maxcd = $row["maxcd"]; ?>
Add new CD:
@mysql_close($dbcnx); ?>