Defalut Value in MySql

abhinav_shah

I created a table in mysql :
create table mytab(name varchar(20), address varchar(20) not null default 'none');

Now from a html form i take the value for address. Now if somebody dosen't enter anything in the address field the default value should go into the table. But this is not happening. Instead nothing is going in the address field and when I display the table contents , address field comes as a blank.

Can somebody help...

raver

so let me understand....you probably have something like:

if ($address="") {
INSERT //...default value }
else {
INSERT //real value }

if you have something like this it should work...
better post the code so we can tell what is the problem...

mathiaus · Last edited by mathiaus on Tue Dec 06, 2005 1:04 am; edited 1 time in total

I'm ill at the moment so my head isnt working 100% so please excuse me if I'm getting the wrong end of the stick.

I'm thinking you have a normal INSERT where you have something like
INSERT INTO mytab (id,name,address) VALUES ('','$name','$address')

now then if $address variable is blank it will insert a blank value into the database. The default value in the structure is for if $address is not inserted like below
INSERT INTO mytab (id,name,address) VALUES ('','$name','')

To get a default value to come into your database you can do1 of a number things. I personally would use the first one below.
If the address is not set set its value to 'none'

kv

This should work

abhinav_shah