Duplicate records
| From: | Steve Marquez | Date: | Fri, 06 Jun 2003 19:40:36 +0000 |
| Subject: | Duplicate records | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-150537@lists.php.net to get a copy of this message | ||
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
smarquez@marquez-design.com
www.marquez-design.com