Deleting an item?

[legrolls]

I know adding an item to inventory is just:

$db->query("INSERT INTO inventory VALUES('',id,$userid,1)");

But what is delete? I tried:

$db->query("DELETE FROM inventory VALUES('',35,$userid,1)");

but nothing happened.

[Lithium]

Re: Deleting an item?

http://dev.mysql.com/doc/refman/5.0/en/delete.html

[AlabamaHit]

Re: Deleting an item?

Use your functions. v2 Has an item remove function.

[CrazyT]

Re: Deleting an item?

Yes

item_add(USERID, ID OF ITEM, ITEM QTY);

I think it's the same way for

item_remove();

If im right.

[legrolls]

Re: Deleting an item?

I followed you, and it worked for ID 1, but how do I make it work for all IDs?

[legrolls]

Re: Deleting an item?

FIXED, thanks everyone.