really simple question (inserting data)

[Rifts]

I'm inserting users into my database using this code

// Make a MySQL Connection
mysql_connect("mydatabase", "login", "password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());

// Add user to database
mysql_query("INSERT INTO members (userid, paid)
VALUES ('$user_id', '0')");

 

the problem is everytime the user load that page it adds him how do I only add if them if there arent added already?

 

thanks

 

[themistral]

You would need to run a select query first to check if the user already exits in the database.

Check if the user_id already exists.

 

Then set up an if statement to say that if the Select query showed no existing member, then run the insert query.

[PFMaBiSmAd]

You can just make the userid column a unique key and let the database enforce uniqueness.

[Rifts]

could someone toss me an example?

 

[AdRock]

$sql="SELECT userid FROM members WHERE userid='$user_id' LIMIT 1";

$result = mysql_query($sql);

$numrows = mysql_num_rows($result);

if($numrows == 0 ) {
    mysql_query("INSERT INTO members (userid, paid) VALUES ('$user_id', '0')");
}
else {
    //already inserted
}