[SOLVED] Not INSERTing nor mysql_error

[rondog]

Im sure its something small that I am just overlooking, but when I hit submit it just refreshes and nothing is getting inserted nor am I getting and error via mysql_error();

<?php
include 'connect.php';
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$email = $_POST['email'];
$pword = md5($_POST['pword']);
$submit = $_POST['submit'];

if($submit != "") {
$emailcheck = mysql_query("SELECT * FROM users WHERE email = '$email';") or die(mysql_error());
$totalemails = mysql_num_rows($emailcheck);
if($totalemails > 0) {
	echo "please fix the following errors: <br>";
	if($totalemails > 0) {
		echo "That email is already registered to a user.";
	}
	exit();
}
$insert = mysql_query("INSERT INTO users (firstname, lastname, email, password) VALUES ('$fname', '$lname', '$email', '$pword');") or die(mysql_error());
if($insert) {
	echo "User ($fname) inserted into DB.";
	} else {
	echo "There was an error inputing the user into the DB.";
	}
}
?>

[MadTechie]

for testing

change

$submit = $_POST['submit'];

if($submit != "") {

 

to

$submit = $_POST['submit'];
var_dump($submit); //debug
if($submit != "") {

[rondog]

gah..ok well that helped me solve it. It was NULL after submit, so I check the form and its name was "Submit" not "submit"

 

hehe thanks..that var_dump function will come in handy!

[MadTechie]

yep, var_dump() and print_r(), are very usful