Re: [PHP] Error #1136

2005-08-25 Thread Jochem Maas
Jay Blanchard wrote: [snip] Column count doesn't match value count at row 1 What does that mean? I have an id auto_increment and it breaks everytime because of that error. This has never happend before... [/snip] This is a MySQL problem and should be asked on a MySQL list, but having said th

Re: [PHP] Error #1136

2005-08-25 Thread Richard Lynch
On Wed, August 24, 2005 11:42 am, George B wrote: > Column count doesn't match value count at row 1 > > What does that mean? I have an id auto_increment and it breaks > everytime > because of that error. This has never happend before... If you REALLY don't want to specify all the column names (a

RE: [PHP] Error #1136

2005-08-24 Thread Jim Moseby
> > Can you include the SQL statement that is creating the error? > > The error basically means you are trying to put more data > into the dB then > you have data cells for. > > For instance : > > Good sql statement: > > $sql = "insert into table (name, address, city, state, zip) > VALUES (

Re: [PHP] Error #1136

2005-08-24 Thread Stephen Johnson
Can you include the SQL statement that is creating the error? The error basically means you are trying to put more data into the dB then you have data cells for. For instance : Good sql statement: $sql = "insert into table (name, address, city, state, zip) VALUES ('$name', '$address', '$city',

RE: [PHP] Error #1136

2005-08-24 Thread Jay Blanchard
[snip] Column count doesn't match value count at row 1 What does that mean? I have an id auto_increment and it breaks everytime because of that error. This has never happend before... [/snip] This is a MySQL problem and should be asked on a MySQL list, but having said that... You have specifi