Everytime I submit my form.. the id increments but everyting else comes out as default values i.e. 0, 0, 0000-00-00
This is my table:
CREATE TABLE editions (
editionid int(11) NOT NULL auto_increment,
volume int(11) NOT NULL default '0',
printnumber int(11) NOT NULL default '0',
releastedate date NOT NULL default '0000-00-00',
PRIMARY KEY (editionid)
) TYPE=MyISAM;
This my code of the page that is being 'post'ed to:
<?php
$volume=isset($POST['volume']);
$printnumber=isset($POST['printnumber']);
$releasedate=isset($_POST['releasedate']);
$link_id = mysql_connect ("runtech1", "the_mirror", "whatever");
mysql_select_db("the_mirror", $link_id);
$sql = "INSERT INTO editions VALUES (NULL, '$volume', '$printnumber', '$releasedate')";
$result=mysql_query($sql,$link_id);
echo $result;
echo ("Edition Successfully added");
echo $volume;
echo $printnumber;
echo $releasedate;
?>