RIRedinPA Posted July 1, 2010 Share Posted July 1, 2010 I'm trying to update an address book type database and what I want to do is add a record if the name field does not contain the name I am adding... something like this: INSERT INTO addressBook (id, name, title, phone, email) VALUES ('', 'skippy jones', 'redundant repeater', '555-555-1212', 'sjones@justanothercorporategiant.com') WHERE NOT EXISTS (SELECT * FROM addressBook WHERE name = 'skippy jones') I get errors with this... Quote Link to comment https://forums.phpfreaks.com/topic/206424-insert-into-table-if-field-value-does-not-exists/ Share on other sites More sharing options...
ejaboneta Posted July 1, 2010 Share Posted July 1, 2010 I don't know if this is the best way, but I just make the field UNIQUE and it will not insert if it exists Quote Link to comment https://forums.phpfreaks.com/topic/206424-insert-into-table-if-field-value-does-not-exists/#findComment-1079834 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.