[aleeexxx]

Originally Posted by Neuro Toxin Make sure your SteamID column is a unique or primary key. Then use INSERT INTO .. ON DUPLICATE UPDATE .. http://www.mysqltutorial.org/mysql-i...te-key-update/

I agree with him,

I use this for my vip system:

For create table:

PHP Code:

CREATE TABLE IF NOT EXISTS vip 
  ( 
     steamid                TEXT UNIQUE
  ); 


And for insert data into without duplicate:

PHP Code:

INSERT OR IGNORE INTO vip (steamid) VALUES ('%s');