multiple inserts

[1zeus1]

Hello
I want multiple inserts into a table
Without an index, insert works

If you created a unique index, the insert does not work

$values = array();

foreach ($get->find('h3[class="r"] a') as $e) {
$sit = strtolower($e -> href);
$values[] = "('$sit')";

}

mysql_query('INSERT INTO xsit (var) VALUES '.implode(',', $values));

thanks for your help

[Bonesnap]

Add the keyword IGNORE after INSERT. It will discard any inserts without error that would cause a duplication error.