Hi All,
I found out how to do it already. Thanks for the help.
mysql_error() was the key..
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-----Original Message-----
From: Ow Mun Heng
Sent: Wednesday, June 25, 2003 10:03 AM
To: [EMAIL PROTECTED]
Subject: PHP & Mysql Error Code 1062 - Duplicates found
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
