Can't get this thing to work... :(

ashley526

Okay here is what I am trying to do. I want to have my members be able to refer their friends to our mailing database. Anyway I got the stuff set up and almost working, can you tell me what I did wrong?

Thanks ahead of time!!

<body bgcolor="#D6CAD8" color="#D6CAD8">
<?php 
$server = "localhost";  

$user = "username";  

$password = "password";  

$database = "db";  


mysql_connect($server, $user, $password) or die(mysql_error()); 
mysql_select_db($database) or die(mysql_error()); 



if (empty($_POST['name'])) { 
    echo "You didn't enter your name.<br />"; 
    $error = 1; 
} 

if (empty($_POST['email'])) { 
    echo "You didnt enter a email address.<br />"; 
    $error = 1; 
} 


if (empty($_POST['refer'])) { 
    echo "You didn't enter your refferrer.<br  />"; 
    $error = 1; 
} 


if (!$error) {
    $query = "INSERT INTO emailads VALUES('{$_POST['id']}', '{$_POST['name']}', '{$_POST['email']}', '{$_POST['refer']}',)"; 
    $result = mysql_query($query); 

if (!$result) { //error w/ db 
    echo "Sorry, your info couldn't be entered right now, please try again later."; 
} else { 
    echo " <html> <div align=\"center\">
  <center>
  <table border=\"4\" width=\"67%\" cellspacing=\"4\" bgcolor=\"#D8C7E0\" bordercolor=\"#49354F\">
    <tr>
      <td width=\"100%\">&nbsp;
        <blockquote>
          <p align=\"center\"><font face=\"Tahoma\" color=\"#49354F\"><font size=\"5\">Thank you for submitting, the below information has been sent to the Database!</font> <br> <br> <br> </font></p>
          <div align=\"center\">
            <table border=\"0\" width=\"218\">
              <tr>
                <td width=\"210\">
                  <p align=\"left\"><font face=\"Tahoma\" color=\"#49354F\"><font size=\"4\">Name:</font>
                  {$_POST['name']}</font></p>
                  <p align=\"left\"><font face=\"Tahoma\" color=\"#49354F\"><font size=\"4\">Email Address:</font>
                  {$_POST['email']}</font></p>
                  <p align=\"left\"><font face=\"Tahoma\" color=\"#49354F\"><font size=\"4\">Refferrer:</font>
                  {$_POST['refer']}</font></p>
                  <p align=\"left\"><font face=\"Tahoma\" color=\"#49354F\"><font size=\"4\">ID:</font>
                  {$_POST['id']}</font></p>

          </td>
          </tr>
        </table>
      </div>
      <p>&nbsp;</p>
    </blockquote>
  </td>
</tr>
  </table>
  </center>
</div></html>"; 
    } 
} 
?>

Okay there is the part that connects to the database....

ashley526

And here is my form to do it by:

<html>
<body bgcolor="#D6CAD8" color="#D6CAD8">

<p>&nbsp;</p>

<div align="center">
  <table border="4" width="409" bordercolor="#49354F" bgcolor="#D8C7E0" cellspacing="5" height="264">
    <tr>
      <td bgcolor="#E9DFEE" width="385" height="254">
        <p align="center">&nbsp;</p>
        <blockquote>
        <p align="center">
<font face="Tahoma" color="#B53548" size="5">Refer Your Friends to our
Database!!!</font>
        <p align="center">
&nbsp;
<form action="save.php" method="post">
<p align="center"><font face="Tahoma" color="#49354F">Name:</font>
<p align="center"><font face="Tahoma" color="#49354F"><input type="text" name="name" size="25"></font>
<p align="center"><font face="Tahoma" color="#49354F"><br>
Email Address:</font></p>
<p align="center"><font face="Tahoma" color="#49354F"><input type="text" name="email" size="25"></font></p>
<p align="center"><font face="Tahoma" color="#49354F">Referrer's Name:</font></p>
<p align="center"><font face="Tahoma" color="#49354F"><input type="text" name="refer" size="25"></font></p>
<p align="center"><font face="Tahoma" color="#49354F"><br>
</font><font face="Tahoma" color="#B53548">
<input type="Submit" value="Submit Name" name="Submit Name">
</font></p>
</form>
        </blockquote>
      </td>
    </tr>
  </table>
</div>

</body>
</html>

jdiver

For starters, what is the problem you're having? What is the table structure where you're trying to enter the data? Is the "ID" field you're trying to insert (which isn't created anywhere btw) an auto-incrementing field in the table?

I'm guessing your query is the problem. Try this for the query:

$query = "INSERT INTO emailads (id, name, email, refer) 
VALUES('', '" . $_POST['name'] . "', '" . $_POST['email']} . "', '" . $_POST['refer'] . "')";

ashley526

Yeah the ID was an auto-incrementing field, sorry!

Thank you so much your query made it work!!!!!!

Ash