Thank you. I got the expected results.
I’m using
`guidelines_signed` varchar(3) NOT NULL DEFAULT 'no'
But still, when I complete the form and leave the checkbox empty, I get the error message
Column 'guidelines_signed' cannot be null
INSERT INTO `clients`
(`account_num`, `title`, `first_name`, `middle_name`, `last_name`,
`age`, `sex`, `guidelines`, `guidelines_signed`, `signed_date`,
`home_address1`, `home_address2`, `home_city`, `home_prov`,
`home_postal`, `home_phone`, `phone_msg`, `cell_phone`, `work_phone`,
`work_ext`, `email`, `home_mail`, `mail_address1`, `mail_address2`,
`mail_city`, `mail_prov`, `mail_postal`, `contact_notes`,
`inquiry_type`, `other_inquiry_type`, `ask_notes`, `visit_date`,
`time_spent`, `assignment_date`, `coordinator_id`, `referred_by`,
`repeat_client`, `repeat_notes`, `careplanner_id`, `case_status`,
`status_change_date`, `church_id`) VALUES ('16-00028-ff', 'Ms', 'f', '',
'f', '17', 'Female', 'yes', NULL, '', 'f', '', 'd', 'ON', '', '', 'no',
'', '', '', '', 'yes', '', '', '', 'ON', '', '', 'General Counselling',
'', '', '2016-03-11', '4', '', '3', '', 'not sure', '', '', 'Active',
NULL, '1')"
I’m using phpmyadmin in XAMPP to develop this application. Could it be that there is an issue with my installation of phmyadmin?