how to prevent duplicate enteries

[Cool Surfer]

Hi
I how can I prevent duplicate enteries in mysql database.
I set slim browser to auto refresh every second, as I was hit n trying
codes, learning my myself from online sites.

suddenly i saw in phpmyadmin theat there were 44 duplicate entries already. Ho can i make an error appear if similar entry exists.

 <?php
include 'conn.php';
//create table record
 
mysql_query 
 
("CREATE TABLE record(
id INT AUTO_INCREMENT NOT NULL,
names VARCHAR (33),
pwd1 VARCHAR(44),
pwd2 VARCHAR(33),
email VARCAR (33),
notes VARCHAR (99))");
 
 
echo '<br>';
echo 'table record created!!';
 
?>  

[kakariko81280]

You don't say how many columns need to match to be a duplicate, but it looks like a table of users so I'd assume duplicates mean two records with the same name.

From the Mysql documentation

CREATE TABLE record(
id INT AUTO_INCREMENT NOT NULL,
names VARCHAR (33),
pwd1 VARCHAR(44),
pwd2 VARCHAR(33),
email VARCAR (33),
notes VARCHAR (99),
primary key(names))

I've not tested this code because I don't have mysql handy, but if it doesn't work then you can refer to the documentation to fix it up.

This puts a primary key index on the names colmun, requiring that the field be populated and unique. If you try to put in another record with a duplicate name then it will raise a primary key violation error and prevent you from doing it.

Let us know how you get on,

Chris...

[Cool Surfer]

Thanks, it seems logical n should work. Will try it.