Can anyone see the error

[NZ_Kiwis]

I can not see the error.... can someone else please help.

code=php Values('','$header','$author','http://www.......com/images/manawatu_sm.jpg','$body','$source','MRL','$nowtime','$MAIN','$PMR','$NPL','$OHA','$BCC','$FAL','$MAN')") or die("INSERT error: ".mysql_error());
[/code]

INSERT error: Column count doesn't match value count at row 1

[bogu]

NZ_Kiwis wrote:

I can not see the error.... can someone else please help.

code=php Values('','$header','$author','http://www.......com/images/manawatu_sm.jpg','$body','$source','MRL','$nowtime','$MAIN','$PMR','$NPL','$OHA','$BCC','$FAL','$MAN')") or die("INSERT error: ".mysql_error());
[/code]

INSERT error: Column count doesn't match value count at row 1

The error say's everithing, how many fields do u have and how many values do u have?

That's why I use syntax like this:

INSERT INTO *** SET
field_1 = 'value_1',
field_2 = 'value_2',
field_3 = 'value_3',
field_4 = 'value_4',
.....
field_n = 'value_n'

[n_wattam]

at the end before your mysql error check you have a

")

as a closing statement, yet you dont have one at the begining.

[bogu]

n_wattam wrote:

at the end before your mysql error check you have a

")

as a closing statement, yet you dont have one at the begining.

That is because in the begining he have:

mysql_query ("INSERT ....

strip that from the example ...

[rincewind456]

You have 'MRL' in your values list but do not have the corresponding field.