# MySQL has 2 methods for handling this: REPLACE INTO people(id,name,email) VALUES (in_id, in_name, in_email); INSERT INTO people(id,name,email) VALUES (in_id, in_name, in_email) ON DUPLICATE KEY UPDATE name='$in_name', email='$in_email';