Quick Search:
 
 mySQL: Check for duplicates and delete duplicates from database. Jump to:  
Category: >> mySQL >> Check for duplicates and delete duplicates from database.  

<< last 

Snippet Name: Check for duplicates and delete duplicates from database.

Description: Before a user submits data to mysql, check for and remove duplicate entries before the data is entered into the database.

Comment: (none)

Language: PHP, MYSQL
Highlight Mode: PLSQL
Last Modified: March 16th, 2009

$check = mysql_query("SELECT * FROM `table` WHERE `field` = '$value'");
 
IF (mysql_num_rows($check) > 0){
     // Duplicate EXISTS. Remove it
     mysql_query("DELETE FROM `table` WHERE `field` = '$value' LIMIT 1");
}
 
// INSERT NEW data
mysql_query("INSERT INTO `table` (`field1`) VALUES ('$value1')");  


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org