help

[dmcdaid]

Need Help when i try to give an item to a user via staff panel

 

QUERY ERROR: Column count doesn't match value count at row 1
Query was INSERT INTO inventory VALUES('',13,1,1,'0','N')

 

Heres the code

$db->query("INSERT INTO inventory VALUES('',{$_POST['item']},{$_POST['user']},{$_POST['qty']},'0','N')");

[Silver]

Re: help

post up the fields in your sql table for items

[dmcdaid]

Re: help

 

itmid 	itmtype 	itmname 	itmdesc 	itmbuyprice 	itmsellprice 	itmbuyable 	effect1_on 	effect1 	effect2_on 	effect2 	effect3_on 	effect3 	weapon 	armor

[Silver]

Re: help

gah, i meant inventory, sorry...plz post inventory fields

[dmcdaid]

Re: help

inv_id inv_itemid inv_userid inv_qty

[Silver]

Re: help

$db->query("INSERT INTO inventory VALUES('',{$_POST['item']},{$_POST['user']},{$_POST['qty']})");

try that

[dmcdaid]

Re: help

Works a charm Thanks

[Silver]

Re: help

yw