If you are violating a primary key, try creating a sequence, and then passing this sequence name (i.e. nID.NextVal) as your parameter in the values of your query. This will automatically give you a new unique number in the sequence you created. Lex -----Original Message----- From: Keven Jones [mailto:keven_jones@hotmail.com] Sent: Thursday, April 03, 2003 5:18 PM To: php-db@lists.php.net Subject: Can't Insert more than 1 record Hello All, I am having a problem inserting records into my Database. I am passing fields from a FORM to my php program that adds 1 record to my DB. It will create the first attempt just fine, however any attempt after the 1st fails. I have to delete the existing row in order to add a new record. Anyone know what I am doing incorrectl? KJ _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
