MySQL problem

Linear Mode

MySQL problem

Vince
Spam Machine

Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0

#6

01.06.2014, 10:55

Combine pid and item to make a unique key. Then use only a single query, rather than two:

PHP код:



INSERT INTO playerinventory (pid,item,amount) VALUES (%d, %d , %d) ON DUPLICATE KEY UPDATE amount = %d

See also here for a similar structure: https://sampforum.blast.hk/showthread.php?tid=505081

Find

Reply

« Next Oldest | Next Newest »

Messages In This Thread

MySQL problem - by PakPak - 31.05.2014, 14:42

Re: MySQL problem - by nmader - 31.05.2014, 14:45

Re: MySQL problem - by PakPak - 31.05.2014, 14:47

Re: MySQL problem - by nmader - 01.06.2014, 05:05

Re: MySQL problem - by DobbysGamertag - 01.06.2014, 05:13

Re: MySQL problem - by Vince - 01.06.2014, 10:55

View a Printable Version

Forum Jump:

Users browsing this thread: 1 Guest(s)