How to check if a row already exists in a table?

[ferpadro]

I have a table with 8 fields, one of them is of the id type with auto_increment property. I want to do an INSERT operation in my database only if the value of the 7 remaining fields to insert (excluding id) do not already exist in the table. How can i do it?

 

Thanks in advance 

[pocobueno1388]

You would do a query to check if there is a row that already exists with that same information.

 

<?php

$query = "SELECT col1 FROM table WHERE col1='$col1' AND col2='$col2' AND col3='$col3' ...";
$result = mysql_query($query)or die(mysql_error());

if (mysql_num_rows($result) < 1){
   //there were no rows with the same information, so add it here
}

?>