Column Count Error.

[Z?v??]

I have added a new field to my items table and now when I got to create an item in my staff panel (on v2) it gives me the QUERY ERROR: Column count doesn't match value count at row 1

I know I have to add something into the staff_items.php file but I don't know exactly how to do it.

I believe this is the part of staff_items.php that needs edited...

 

$m=$db->query("INSERT INTO items VALUES('',{$_POST['itmtype']},'$itmname','$itmdesc',{$_POST['itmbuyprice']},{$_POST['itmsellprice']},$itmbuy, '{$_POST['effect1on']}', '$efx1', '{$_POST['effect2on']}', '$efx2', '{$_POST['effect3on']}', '$efx3', $weapon, $armor)");
print "The {$_POST['itmname']} Item was added to the game.";
stafflog_add("Created item {$_POST['itmname']}");

[seanybob]

Re: Column Count Error.

 

$m=$db->query("INSERT INTO items VALUES('',{$_POST['itmtype']},'$itmname','$itmdesc',{$_POST['itmbuyprice']},{$_POST['itmsellprice']},$itmbuy, '{$_POST['effect1on']}', '$efx1', '{$_POST['effect2on']}', '$efx2', '{$_POST['effect3on']}', '$efx3', $weapon, $armor, '')");
print "The {$_POST['itmname']} Item was added to the game.";
stafflog_add("Created item {$_POST['itmname']}");

[Z?v??]

Re: Column Count Error.

Thank bro, worked perfect. +1