Jump to content
Larry Ullman's Book Forums

Recommended Posts

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

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

 Share

×
×
  • Create New...