how to prevent duplicate entries

[hello123]

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!!';

?>

[iversonm]

make the column unique

there will be a button a u specificallay or

ALTER TABLE `record` ADD UNIQUE (
`names` 
) 

if you have the table created

change names to whatever you want unique