--- a/admin/import.php +++ b/admin/import.php @@ -98,17 +98,17 @@ $result = mysql_query($contractNoticeInsert); if ($result) $success++; -else echo $data[2] . " failed CN insert.<br>". mysql_error() ." <br> $contractNoticeInsert <br><br>\n"; +else if (strpos(mysql_error(),"Duplicate entry") === false) echo $data[2] . " failed CN insert.<br>". mysql_error() ." <br> $contractNoticeInsert <br><br>\n"; - //$result = mysql_query($agencyInsert); + $result = mysql_query($agencyInsert); if ($result) $success++; -else echo $data[2] . " failed agency insert.<br>". mysql_error() ." <br> $agencyInsert <br><br>\n"; +else if (strpos(mysql_error(),"Duplicate entry") === false) echo $data[2] . " failed agency insert.<br>". mysql_error() ." <br> $agencyInsert <br><br>\n"; $result = mysql_query($supplierInsert); if ($result) $success++; -else echo $data[2] . " failed supplier insert.<br>". mysql_error() ." <br> $supplierInsert <br><br>\n"; +else if (strpos(mysql_error(),"Duplicate entry") === false) echo $data[2] . " failed supplier insert.<br>". mysql_error() ." <br> $supplierInsert <br><br>\n"; -echo "<hr>\n"; +//echo "<hr>\n"; } $row++; @@ -117,3 +117,4 @@ fclose($handle); } ?> +