june_c21 Posted November 22, 2007 Share Posted November 22, 2007 hi, why i getting this error? i can't figure out what's the problem SQL query: INSERT INTO report( work_id, reg_no, unit, title1, fault_rep_id.start_date, end_date, secr_recd, facilitator ) VALUES ( '$work_id', '$reg_no', '$unit', '$title1', '$fault_rep_id', '$start_date', '$end_date', '$secr_recd', '$facilitator' ) MySQL said: #1136 - Column count doesn't match value count at row 1 Link to comment https://forums.phpfreaks.com/topic/78341-solved-help-error/ Share on other sites More sharing options...
teng84 Posted November 22, 2007 Share Posted November 22, 2007 your field list is only 8 while the record to be inserted id nine maybe this is what causes the error fault_rep_id.start_date you put dot instead of comma Link to comment https://forums.phpfreaks.com/topic/78341-solved-help-error/#findComment-396409 Share on other sites More sharing options...
june_c21 Posted November 22, 2007 Author Share Posted November 22, 2007 thanks a lot Link to comment https://forums.phpfreaks.com/topic/78341-solved-help-error/#findComment-396413 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.