CCNA, CCNP, MCSA, CCNA Final Exam, All Answer Test Module With 100/100

I am working in PHP. Please what's the proper way of inserting new records into the DB, which has unique field. I am inserting lot of records in a batch and I just want the new ones to be inserted and I don't want any error for the duplicate entry. Is there only way to first make a SELECT and to see if the entry is already there before the INSERT - and to INSERT only when SELECT returns no records? I hope not. I would like to somehow tell MySQL to ignore these inserts without any error. Thank you Source: Tips4all

I have a script where I submit some fields that get entered into a MySQL database when I submit it now it goes through successfully but never gets inserted into the database if one of the fields has an apostrophe. What can I modify to get this to work? if ($_POST) { $name = trim($_POST['your_name']); $email = trim($_POST['your_email']); $answers = $_POST['answers']; $i = 0; foreach ($answers as $a) { if (trim($a)) $i++; } if ($name && $email && $i >= 40) { $array = array(); $q = mysql_query("select * from fields"); while($f = mysql_fetch_array($q)) $array[$f['label']] = $answers[$f['ID']]; $array = serialize($array); $time = time(); $ip = $_SERVER['REMOTE_ADDR']; $token = md5($time); $result = mysql_query("insert into data (submit_name, submit_email, submit_data, submit_confirm, submit_time, submit_ip, submit_token) values ('$name', ...