Give Item Error

[sevendet]

whenever i go in the admin panel to give out an item i get this error

Column count doesn't match value count at row 1

that happens when i try to give any item

[Decepti0n]

Re: Give Item Error

match the # of columns used in the insert query to the number of columns in the table in the db

[Vorlen]

Re: Give Item Error

Pop the code for the query here, or PM me and we can go over it together. :)

[UCC]

Re: Give Item Error

If you modify tables, you're going to have to modify queries inserting into those tables....most the time anyway

[hunter]

Re: Give Item Error

Heres the problem were having we add a line in the inventory table and then when trying to send from the admin panel we get the Column count doesn't match value count at row 1 error

[Decepti0n]

Re: Give Item Error

change the query in the admin panel

[rfw2003]

Re: Give Item Error

if you go through when you are doing mods to the code, and change the main queries to specify the info that you want to update or insert into the DB you will never have to modify the queries again, here is an example of what I'm talking about

 

mysql_query("INSERT INTO `items` (`itmid`, `itmtype`, `itmname`, `itmdesc`, `itmbuyprice`, `itmsellprice`, `itmbuyable`) VALUES (NULL, '8', '{$_POST['itemname']}', '', '0', '0', '0')",$c);

 

I highly suggest that you do it at least on the registration.php file so that anytime you add new features to the game that require adding more fields to the users table, you will not have to go back and modify the registration table.

R.F.