Possible Duplicate:
How to ‘insert if not exists’ in MySQL?
I have a few inserts and I only want them to actually insert if there isn't already the same information in there.
I only want the insert to run using WHERE NOT EXISTS, would anybody be able to help me adding that to my queries?
Queries:
$db->Query("INSERT INTO `surfed` (site) VALUES('".$id."')");
Thanks so much!
Use the IGNOREkeyword
INSERT IGNORE INTO surfed (user, site) VALUES('".$data['id']."', '".$id."')
If you have a unique key constraint on the user-site combination then it would normally generate an error on duplicates and abort the insertion. Using ignore in the insert statement will ignore the error and just not insert anything.
If you use the IGNORE keyword, errors that occur while executing the INSERT statement are treated as warnings instead. ... With IGNORE, the row still is not inserted, but no error is issued.
See here for more infos about it
user-site combination.surfed (site) VALUES('".$id."')"); + $db->Query("INSERT IGNORE INTO surfed (site) VALUES('".$sit['id']."')"); Basically lots of people view lots of different sites but I only want a certain site to be submitted once in to the site column.site? If so, then the insert should fail and not return an error.You should be able to go with mysql_num_rows. If that returns a value of 0, then there is nothing in your table matching what you want to insert. (WHERE NOT EXISTS). So make something like "if mysql_num_rows = 0 then insert else do nothing".
First your two columns need to be a combined key, then you can use INSERT IGNORE as outlined by juergen d or use
ON DUPLICATE KEY UPDATE user=user
See similar question here: INSERT ... ON DUPLICATE KEY (do nothing)
For the revised question of only having a site column, make sure the site column is a unique key or primary key and then use
$db->Query("INSERT INTO `surfed` (site) VALUES('".$id."') ON DUPLICATE KEY UPDATE site=site");
