sandari Posted January 26, 2013 Share Posted January 26, 2013 Table structure is: ID int(11) Auto Primary Key Not NULL DetoxUnit varchar(255) Address1 varchar(255) Address2 varchar(255) Suburb int(11) Phone varchar(255) Fax varchar(255) Contact varchar(255) Command is: insert into tblDetoxUnits (DetoxUnit, Address1, Address2, Suburb, Phone, Fax, Contact) values('Dr Gumley\'s Sanitorium', '21 Acidic way', '', '13', '3210 9999', '3210 8888,' 'Michelle'); The error message is: Column count doesn't match value count at row 1 in C:\...\add_detox_unit.php on line 87 As far as I can see I am trying to insert 7 values into their 7 coresponding columns. What am I missing? Link to comment Share on other sites More sharing options...
Jaepee Posted January 26, 2013 Share Posted January 26, 2013 Hello Sandari '3210 8888,' should be '3210 8888', I've been there , Iv'e done that. 1 Link to comment Share on other sites More sharing options...
sandari Posted January 26, 2013 Author Share Posted January 26, 2013 Thanks Jaepee, It's too easy to make such a silly mistake like this. Took your advice and all is now good. Link to comment Share on other sites More sharing options...
Jaepee Posted January 27, 2013 Share Posted January 27, 2013 That's Great! Code on bruda! or (Sista!... profile didn't say gender) Im just paying it forward when I can, cause there is a ton of help on this forum. This is the only spot on the internet for coding help (as far as I am concerned) that is worth while. I keep coming back and learning from all the loyal members, especially when I read other members coding troubles & solutions. jp Link to comment Share on other sites More sharing options...
Recommended Posts