[SOLVED] Compare/Insert only NEW records-- not working

[CodeMama]

I am trying to insert only new records into a db, but my code keeps inserting all the records making duplicates

Here's my code:

 

//compare entries and insert new inspections to the database
//call what is in the database

    $query = "SELECT * FROM  restaurants  WHERE name LIKE '$mysql_name' AND address LIKE '$mysql_address' AND inDate LIKE '$mysql_inDate' AND inType LIKE '$mysql_inType'" ;
     $result = mysql_query($query) or die(mysql_error());
     
    
   
   
    If (mysql_num_rows($result) == 0) {
   
   
  $sql = "INSERT INTO `restaurants` (name, address, inDate, inType, notes, critical, cviolations, noncritical)  VALUES (" ;
  $sql .= " '$mysql_name', '$mysql_address', '$mysql_inDate', '$mysql_inType', '$mysql_notes', '$mysql_critical', '$mysql_cviolations', '$mysql_noncritical')";
    

        $result = mysql_query($sql) or die(mysql_error());

    }

echo $result;

};