zero value

[Anon]

Hi ,
i currently have a form that inserts values into a MySQL database. At the moment, if the user doesn't type in a value it puts the value "0" into the database. How do i make it so that it inserts no value at all....blank?

My database column is as follows:

year_released smallint(5) unsigned DEFAULT '0' NOT NULL,

i tried making it NULL and removing the default value "0" but with no success.

Any ideas?

micmac

[fitzbean]

I don't think you can put a blank value for a integer.

[ccranium]

You could explicitly insert NULL in the PHP code. So if the form variable is empty, make the variable = NULL.

You could also try making the default value NULL, but I'm not entirely certain if that's possible. Perhaps DEFAULT '\0', but I doubt it.

As far as I know there's no restrictions on any data type regarding null values, except maybe bits.