manhattes

Members

Community Answers

manhattes's post in preventing duplicates was marked as the answer February 23, 2016

Jacques1 Advanced Member
1,770 posts Posted Yesterday, 10:23 PM
INSERT IGNORE with Link being a primary or unique key.
Like This Best Answer Quote MultiQuote Thanks. Changed the row value to primary.
manhattes's post in Deleting Duplicate error was marked as the answer February 22, 2016

Thanks it is slow but worked. my script pulls in an RSS feed and sometimes pulls in data that was already pulled in.
$citable= "INSERT INTO TableName (Company, Form, Date, Link) VALUES ('" . $FnumI ."',' " . $Form ."','" . $msqldate ."','" . $Flink ."') ON DUPLICATE KEY UPDATE Company='" . $FnumI ."', Form='" . $Form ."', Date='" . $msqldate ."', Link='" . $Flink ."'"; Is there a way I can only record the data if Link does not exist?
Yes there is always an id.