[Vince]

A subquery needs to be a full fledged query.

PHP Code:

UPDATE `player_inventory` SET `amount` = `amount` + (SELECT `amount` FROM player_inventory WHERE `id` = %d) WHERE `id` = %d 


And oh, don't use quotes around integer values. It prevents indexes from being used which will needlessly slow down your queries.