Hi PHP'ers, I've got a question regarding the input of (multiple) data into mysql through PHP.
If there is already an entry in the database, then an mysql will generate an error 1062 stating that the entry is a duplicate. (This will happen only if I input the data through mySQL using xterm, if I use PHP, then I only get the 'duplicate entry found', partly cause I don't know how to get the error code as well as the duplicate entry returned to PHP to be output'ed to the browser. Below is my code. $my_query is concatenated from an array. $my_query = $my_query. "\n('".$SN[$i]."','".$DCM[$i]."','".$Supp[$i]."','".$time_now."'),"; $query = "INSERT INTO pioneer(serial_no,dcm,supplier,fa_timestamp) VALUES $my_query;"; $result = mysql_db_query('tracker',$query); if ($result) echo "<br><br>".mysql_affected_rows()." Drives & DCM combo inserted into database."; else echo "\n<br><br>Duplicate entry found. Data not inserted."; Can anyone help me out? Cheers, Mun Heng, Ow H/M Engineering Western Digital M'sia DID : 03-7870 5168 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php