[SOLVED] double adding

[nathanmaxsonadil]

I have this code to add the logged in user's email to the mysql database

 

echo "<br/><ul><li><a href='stixy.php?insert=1'>Add your self to the list</a></li></ul>";
if(isset($_GET['insert']) && $_GET['insert'] == '1'){
    $sql = "INSERT INTO emailists (stixy) VALUES ('" . $session->userinfo['email'] . "')";
        if($sqlres = mysql_query($sql)){
            echo 'email address added';
        }else{
            echo mysql_error();
        }
}

 

the only problem is that you can add you email twice

Is there any way so that if you've already added your email it does not add it again?

[Vizor]

http://www.sqlteam.com/article/using-exists

[hitman6003]

Either do a query to check for it already being in the table, or add a unique index to your table and catch the error letting the user know that they have already been added.

[trq]

<?php
echo "<br/><ul><li><a href='stixy.php?insert=1'>Add your self to the list</a></li></ul>";
if(isset($_GET['insert']) && $_GET['insert'] == 1) {
 $sql = "SELECT stixy FROM emaillist WHERE stixy = '{$session->userinfo['email']}'";
 if ($result = mysql_query($sql)) {
   if (!mysql_num_rows($result)) {
     $sql = "INSERT INTO emailists (stixy) VALUES ('" . $session->userinfo['email'] . "')";
     if ($sqlres = mysql_query($sql)){
       echo 'email address added';
     } else {
       echo mysql_error();
     }
   } else {
     echo "email address already exists";
   }
 }
}
?>

[hitman6003]

You could also use "ON DUPLICATE KEY UPDATE"...

 

http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html

[nathanmaxsonadil]

it does not add anything even if your email address is not yet added (using thrope's code)

[trq]

Check for errors. I spelt your field name differently.

 

<?php
echo "<br/><ul><li><a href='stixy.php?insert=1'>Add your self to the list</a></li></ul>";
if(isset($_GET['insert']) && $_GET['insert'] == 1) {
  $sql = "SELECT stixy FROM emailists WHERE stixy = '{$session->userinfo['email']}'";
  if ($result = mysql_query($sql)) {
    if (!mysql_num_rows($result)) {
      $sql = "INSERT INTO emailists (stixy) VALUES ('" . $session->userinfo['email'] . "')";
      if ($sqlres = mysql_query($sql)){
        echo 'email address added';
      } else {
        echo mysql_error();
      }
    } else {
      echo "email address already exists";
    }
  } else {
    echo mysql_error();
  }
}
?>

[nathanmaxsonadil]

thanks 

[nathanmaxsonadil]

one more question

is there a way so that the add youself to the list button changes when you are on the list and instead says remove myself from the list and removes you?

[trq]

Of course there is. You wanna try writting some code?

[nathanmaxsonadil]

I wrote the code to delete it but I dont know how to change the add yourself to the list button dynamicly

[nathanmaxsonadil]

OK I figured this all out