CREATE TABLE Ukkiss_Memberlist (
user_name VARCHAR(32) NOT NULL,
password VARCHAR(255) NOT NULL,
gender VARCHAR(7) NULL,
email VARCHAR(50) NOT NULL,
date_modified TIMESTAMP,
date_joined TIMESTAMP,
PRIMARY KEY(user_name) );
Notice the highlighted line, well thats so "registrants" can select whether they are male or female by clicking the relevant radio button, (i did have it set to "NOT NULL") however its causing me problems, everything works ok on testing but these radio buttons fail me all the time and then registration fails even though a button has been selected.How can i change that line so that the clicked radio button returns whether the "new user" is male or female to my database, the image below shows what error is made upon submitting the form..
Thanks for your time in reading this post..