[SOLVED] Controlling Duplicate Records

[joshblue]

 

Hi! Can somebody give me an idea or a simple code that could control duplicate records in PHP/MySQL?  ???

[teng84]

you can use unique as your fields property..

 

or check first before inserting

 

eg...

$user = $_POST['user'];
$query = " select * from table where name = '$user'";
$result =mysql_query($query);
if(mysql_num_rows($result)<=0){
   //INSERTHERE
}else{
    //dontinsert
}

[joshblue]

you can use unique as your fields property..

 

or check first before inserting

 

eg...

$user = $_POST['user'];
$query = " select * from table where name = '$user'";
$result =mysql_query($query);
if(mysql_num_rows($result)<=0){
   //INSERTHERE
}else{
    //dontinsert
}

 

Got it! Thanks!