Check for duplicates before inserting

by

You want to do the following:

$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 code ...
}

See Here for more information.

More Related Contents:

  1. How to prevent duplicate usernames when people register?
  2. Php date() Date and time is stuck [closed]
  3. inserting information and image in php and mysql
  4. CodeIgniter – foreach loop
  5. Project Links do not work on Wamp Server
  6. PHP/MySQL insert row then get ‘id’
  7. Show values from a MySQL database table inside a HTML table on a webpage [duplicate]
  8. Laravel migration: unique key is too long, even if specified
  9. Laravel Eloquent select all rows with max created_at
  10. MySQL – count total number of rows in php
  11. Advantages Of MySQLi over MySQL [closed]
  12. What does a successful MySQL DELETE return? How to check if DELETE was successful?
  13. check if the query results empty row mysqli [duplicate]
  14. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  15. double results in my array ( mysql_fetch_array )
  16. How best to get someone’s ‘rank’ from a scores table with php and mysql without looping
  17. php:Store image into Mysql blob, Good or bad?
  18. How to get rid of MySQL error ‘Prepared statement needs to be re-prepared’
  19. Using Prepared Statement, how I return the id of the inserted row?
  20. Replacing \r\n with PHP
  21. How to check if a value already exists to avoid duplicates?
  22. How to use MySQL Found_Rows() in PHP?
  23. How does {} affect a MySQL Query in PHP? [duplicate]
  24. When should I close a database connection in PHP?
  25. Backup a mysql database and download as a file
  26. MYSQL select a piece of a string and order by that piece
  27. Is a BLOB converted using the current/default charset in MySQL?
  28. php connection pooling mysql [duplicate]
  29. PHP/MySQL Pagination
  30. Limit pagination page number

Leave a Comment