View Single Post
Old 01-11-2003, 07:51 AM   #3 (permalink)
Henry
Registered User
 
Join Date: Dec 2002
Location: Chicago
Posts: 13
Henry is on a distinguished road
phpmyadmin

I am using phpmyadmin. When I set up the table, I created the integer columns by typing 'field name' Int, and the table was created with null-yes, default NULL for all of the columns, including the integer ones. I'm not having any problems wiht any of the other columns, when they are left blank on the form, there is nothing entered into the column in the table. The default settings are the same for all of the comumns in the table, but the integer columns are defaulting at zero, in spite of the DEFAULT setting.

Should I just change these columns to enum with the five possible numbers set as the values? It seems like the easiest solution, I just wanted to makle sure that it was the only quick one.

Thanks
Henry is offline   Reply With Quote