Member Avatar for Passy 
                $sql="SELECT * FROM `customer_information_table` WHERE `email`='{email}'";
                $result = $db->query($sql);
                      if($db->error)
                        {
                            exit("SQL error.
                                 <a href = './register.php'>return</a>");
                        }

                      if($result->num_rows!==0)
                      {
                        exit("email address already exists.
                             <a href = './register.php'>return</a>");
                      }
Edited by Passy
  • 2 Contributors
  • 1 Reply
  • 127 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for AndreRet

I picked up a few lines that might not have the desired return you want, try the following...

$email = here@there.com; //Sample and not checked for validation...
$sql="SELECT * FROM `customer_information_table` WHERE `email`='".$email."'";
                $result = $db->query($sql);
                      if($db->error)
                        {
                            exit("SQL error.
                                 <a href = './register.php'>return</a>");
                        }
                      if(count($result) > 0)
                      {
                        exit("email address already exists.
                             <a href = './register.php'>return</a>");
                      }
Edited by AndreRet
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.