插入前检查重复项

您要执行以下操作：

$dupesql = "SELECt * FROM table where (name = '$name' AND description = '$description' AND manufacturer = '$manufacturer' AND city ='$city' AND price = '$price' AND enddate = '$end_date')";$duperaw = mysql_query($dupesql);if (mysql_num_rows($duperaw) > 0) {  //your pre ...}

有关更多信息，请参见此处。