MySql help - need to prevent the duplication of information when inserting to DB

[9911782]

Hi
Im am doing the web-based application, where I have to add some information from front-end, and then add it to the database. Now, I would like to get the MySQL statement that will prevent me from adding same thing in 1 table.

Please help me, I need to do this by end of today.

thank you

[manmadareddy]

I hope u need only some fields which are not replicated I mean unique like email.
first identify those fields and just write a select query .
$sql="select count(*) as cnt from tablename where email!='".$_REQUEST['email']."'";
//you can add if you need to check another fields too like $sql." and fname!='".$_REQUEST['fname']."'";
$res=mysql_query($sql);
$result=mysql_fetch_assoc($res);
if(!$result['cnt'])
{
  //here insert statement
}else
{
  //email already exists error message
//same form with $_REQUEST fields filled
}

[9911782]

Hi manmadareddy

its working right now, thank you very much. I took ur advise.

thanks a million.

[fenway]

I'm sorry to say that it's not very good advice... first, never use !=, because no index will be able to utilized.  Second, you don't need to fetch the rows at all... simply use mysql_num_rows() and see if you get back anything.  Third, depending on the application, a UNIQUE KEY restriction on the column is often the better way to go.

[manmadareddy]

Yeah! you are right..I am very sorry for my bad suggestion.
You have given good suggestions for me.
I am very much thankful to you.