Jump to content

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


9911782

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

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.