Just a quick question

[jbrill]

Hey guys,

 

Im trying to insert an email address into my database for a newsletter capture.

 

I have two pages, one page consists of this form:

<form action="newsletter_signup.php" method="GET">
           	<div id="box_content">Sign up!<br />
           	  <input name="newsletter" type="text" value="E-mail Address" id="newsletter" class="text" size="14" />
           	  <input type="image" name="submit" id="button" value="Go" src="images/button_go.jpg" align="absmiddle"/>
           </form>

 

This form is then sent to this page, which should then add that email to the "newsletter" table of the database, in the row "email"

 

here is the code to insert into the database:

<?php
include 'includes/dbconnect.php';
include 'includes/header.php';
$newsletter = $_GET['newsletter'];
?>
<div id="content">
<?php

$insert = "INSERT INTO newsletter (email) VALUES ('".$newsletter."')";
?>
<center><p>Thank you for signing up for our newsletter!</p></center>
<meta http-equiv="refresh" content="3;url=index.php">
</div>
<?php
include 'includes/footer.php';
?>

 

 

[hostfreak]

Is the value of "newsletter" actually being submitted?... to start though, are you getting any errors? It's just not submitting to the database?

[jbrill]

im not getting any errors, it is just not submitting to the database

[jbrill]

anyone??  ???

[emehrkay]

well you never run the query

 

$insert = 'whatever';

$result = mysql_query($insert) or die(mysql_error());

[MmmVomit]

All you're doing is creating a sql query and storing it in a string.  You need to use mysql_query() to run the query and submit the data to the database.