Jump to content

Archived

This topic is now archived and is closed to further replies.

9911782

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

Recommended Posts

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

Share this post


Link to post
Share on other sites
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
}

Share this post


Link to post
Share on other sites
Hi manmadareddy

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

thanks a million.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.