Either the following query:
Code:INSERT INTO users (login, fullName, email) VALUES ('".$login."', '".$fullName."', '".$email."');
I'd like to insert the user data if and only if a login with the name foo is not in the table.
I tried:
Code:INSERT INTO users (login, fullName, email) VALUES ('".$login."', '".$fullName."', '".$email."') on duplicate key update login='foo';
But it always gives me a line of registration.
Bookmarks