is statement

[Anon]

Is there a way to have an if statement in mysql that would insert my query if a feild never exists else do nothing.

Basically I want it to see if a users exists, if it does do nothing, if it doesnt insert it.

I know there are 2 fields that the if statment can insert, 1 if it exists, 1 if it doesnt.

I only want it to insert if the user never exists.

Any one can give me syntax for that using a if statement, if possible.

else I'll use a select statment to detect it, and then insert it if the select statement comes up with nothing.

[Anon]

Figure out what is unique about a user (what makes it definate that a user is a duplicate) and make a unique index on that field or fields. Assuming you want a unique username:

insert ignore into user (username, blah) values ('blah', 'blah')

This will make the insert if the username is different from any other, and not return an error if not.

If you are trying to respond afterwards based on the existance of the username or not, use (assuming mysql):

if (!mysql_query("insert ignore into user (username, blah) values ('blah', 'blah')")) {
print "The username exists";
}

mysql_query returns false if there was a problem with the sql.