why not just make the 'id' field in the table auto_increment? tyler
----- Original Message ----- From: "Steve Marquez" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Cc: "PHP eMail List" <[EMAIL PROTECTED]> Sent: Friday, June 06, 2003 2:40 PM Subject: [PHP] Duplicate records > Hello. > > I am adding a record to a MySQL Database using PHP. I have the records > listed by the field: $id_num. > > I want the DB to be updated only with new id numbers, and return an error if > there is a duplicate number already in the DB. > > Here is the code I am using: > > <?php > > $insert_data = "INSERT into articles > > Values ( '<a href=\"upload_form.php?id_num=$id_num\">edit</a>', '<a > href=\"delete.php?id_num=$id_num\">delete</a>', '$id_num', '$title', > '$author', '$article_contents', '$start_date', '' );"; > > $response = mysql_query( $insert_data, $dbh ); > > > $get_table_data = "SELECT * FROM ccfs"; > $response = mysql_query( $get_table_data, $dbh ); > > ?> > > Can anyone help me? Hope this makes sense. > > Thanks! > > Steve Marquez > Marquez Design > [EMAIL PROTECTED] > > www.marquez-design.com > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php