INSERT question
Posted: Tue May 24, 2005 9:55 pm
how can i insert a record into database if the record doesn't exist. I want to do this in a single query. Please give me a sample query. Thanks.
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
INSERT INTO tb (firstname, lastname) VALUES ('Jack', 'Doe') ON DUPLICATE KEY UPDATE lastname = lastname;Code: Select all
$query = "INSERT INTO directory (fname,lname) VALUES ('$fname','$lname') WHERE concat(fname,' ',lname)!='$fname $lname'";