question on increasing prices for individual players

[s0meone]

How would I write the code to increase the price of an item every time it's purchased by a player for that player only?

[hallsofvallhalla]

create table with fields of itemID, pname, and bought

when a player buys an item have it check to see if a entry is already there by itemID and pname,

if not insert one where bought = 1

if there is already a entry then update it and add 1 to bought. bought will be your counter.

[s0meone]

Thanks again sir halls. You're always helpful.