[Drbbest]

I'm using dreamweaver (yes, laugh)

Before a user submits data to mysql, I want to have the .php page:
check for and remove duplicate entries before the data is entered into the database.



I have don't know how to go about doing this. Thanks for your help!

[landing]

The code would be something like

PHP Code:

$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')");