Help!! newbie over here!!

[jmgarde]

Can anyone help me how to alert the user when they try to enter a duplicate entry in the database using PHP, MySQL and Dreamweaver or anything. Im working on a website that can have only one comment per user. Please help. id be thankful.

[GingerRobot]

You need to search your database to find out the number of posts by that user prior to inserting the data. Something like:

 

$sql = "SELECT COUNT(*) FROM yourtable WHERE username='$name'";
$result = mysql_query($sql) or trigger_error(mysql_error(),E_USER_ERROR);
$num = mysql_result($result,0);

if($num > 0){
    //dont insert give use error message
}else{
    //insert the comment into the database
}

[jmgarde]

thnks.. but i was looking for something like... the user enters the name of the person he want to add a comment to by using a text box and a comment box on the website, when he/she clicks the submit comment button if the name already exists, a message box will appear, notifying him that the name he entered already has a comment.. please help...

[OldWolf]

What he posted would do just that... you just need to apply the form before it, and then collect the name out of the submitted post and set it to the $name var.

[fanfavorite]

$q = mysql_query("SELECT * FROM tablename WHERE Name = '$_POST[name]'");

if ($mysql_num_rows($q) != 0) {

  $message = "The name has already been used.";

} else {

  //submit comment

}

 

[jmgarde]

Thanks a lot guys..i tried it and it really helped a lot