no entries to my database?

[wright67uk]

I'm using the file below, however nothing gets added to my database.

 

I've tested my database connection, and i've echoed $email and $name, can I put this down to incorrect syntax?

 

 

<div id="form">
<form name="form1" method="post" action="form-email.php">
<input type="text" onclick="this.value=''" name="name" class="round" value="name" size="20" />
<input type="text" onclick="this.value=''" name="email" class="round" value="email" size="20"/>
<input type="submit" class="round" name="Submit" value="Register Your interest"/>
</form>
</div>



<?php
if (isset($_POST['Submit'])) {


if ($_POST['name'] != "") {
$name = filter_var($_POST['name'], FILTER_SANITIZE_STRING);
if (!filter_var($name, FILTER_SANITIZE_STRING)) {
$errors .= '* Please enter a valid name.<br/><br/>';
}
} else {
$errors .= '* Please enter your name.<br/>';
}

if ($_POST['email'] != "") {
$email = filter_var($_POST['email'], FILTER_SANITIZE_EMAIL);
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
$errors .= "* $email is <strong>NOT</strong> a valid email address ";
}
} else {
$errors .= '* Please enter your email address.<br/>';
}

if (!$errors) {

$hostname = "###";
$username = "###";
$dbname = "###";
$password = "###";
$con = mysql_connect ("$hostname", "$username", "$password");

if (!$con) {
die ('Could not connect: ' . mysql_error ());
}

mysql_select_db ("###", $con);
$sql = "INSERT INTO NLCUP (name, email) VALUES ('$name', '$email')";

echo '<p style="color: white; margin-left:105px; font-size:22px; padding-top:15px">* Thankyou, we will be in touch soon!<br></p>';
}

else {
echo '<p style="color: white; margin-left:105px; padding-top:15px">' . $errors . 'please try again.</p></div>';
}
}
?>
</div>

[PFMaBiSmAd]

Where exactly is your mysql_query statement in your code?

[Jessica]

Well you never try to run the query. 

mysql_query

 

Awwww.

[wright67uk]

I feel very silly :-(

 

 

...and thank you for the replies.