Jump to content


  • Posts

  • Joined

  • Last visited

Community Answers

  1. manhattes's post in preventing duplicates was marked as the answer   
    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. 
  2. manhattes's post in Deleting Duplicate error was marked as the answer   
    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.
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.