mysql error

[Anon]

Peeps

I have a simple insert into sql statement. But I get an error which I have not seen before. Can anyone tell me what this means

1136: Column count doesn't match value count at row 1

I think there is something wrong with the table of the databse but I cant see it.

Here is the structure

CREATE TABLE wars_opponents (
opp_id int(11) NOT NULL auto_increment,
opp_abb varchar(30) NOT NULL,
opp_name varchar(200),
opp_url varchar(200),
opp_contact_name varchar(200),
opp_icq int(15),
opp_email varchar(200),
opp_mirc varchar(200),
PRIMARY KEY (opp_id),
UNIQUE opp_id (opp_id)
);

??

Lee

[brandonschnell]

and where is the insert statement?

[Anon]

$result = mysql_query("insert into wars_opponents(opp_id, opp_abb, opp_name, opp_url, opp_contact_name, opp_icq, opp_email, opp_mirc) values (NULL,'','$opp_abb','$opp_name','$opp_url','$opp_contact_name','$opp_icq','$opp_email','$opp_mirc')");
if(!$result) {echo mysql_errno). ": ".mysql_error(). "<br>";

[Anon]

Its ok i fixed it.

Thanks