Inserting only unique rows

[stubarny]

Hello,

 

Please could you tell me how to change the query below so that it only gets inserted into the mysql table if the value for the field "website_page_name" is unique? (I already have the field setup as unique in mysql but I think I need to change this insert query as well?)

 

$query="INSERT INTO website_page_names (website_page_name, website_page_name_company, website_page_name_job_specialism, website_page_name_location) VALUES ('$mysql_real_escape_string_website_page_name_with_dashes', '$mysql_real_escape_string_company_name', '$mysql_real_escape_string_job_specialism_phrase', '$mysql_real_escape_string_location')";

 

Thank you for your help,

 

Stu

[The Little Guy]

This will ignore the duplicate:

INSERT IGNORE INTO ....

 

or

 

This will update the duplicate:

INSERT INTO ...  '$mysql_real_escape_string_location') ON DUPLICATE KEY UPDATE my_unique_field = values(my_unique_field)