problem with int type

[wil831]

i have a textbox that asks for the year but allows user to skip this field...the problem is when they leave it blank,a '0' is inputted into the year column... how do i leave it blank or input NULL in the column if nothing is entered in that field?

i've tried this...and it still leaves it as 0.

if (!isset($year) { $year='NULL' }
mysql_query("INSERT into table values(NULL, '$year');

[Norman_Graham]

Not sure, but you certainly have some syntax errors (one missing semi-colon, two missing end brackets, one missing quote, one end bracket in the wrong place):

if (!isset($year)) {
$year='NULL';
mysql_query("INSERT into table values (NULL, '$year')");
}

Norm

[cosminb]

the default for int is 0. if want to be null try with "" or make the column char

[sdjensen]

'NULL' and NULL is not the same.

if (!isset($year) { mysql_query("INSERT into table values(NULL, NULL) "); }
else
mysql_query("INSERT into table values(NULL, '$year') ");