I am having trouble with my script, anyone know why it wont add the data. it acts as if it works, but there is nothing new in the database.

<?php

$fname = $_POST['fname'];
$sname = $_POST['sname'];
$email = $_POST['email'];
$pword = $_POST['password'];
$gender = $_POST['gender'];

$user_name = "root";
$password = "";
$database = "test";
$server = "127.0.0.1";

$db_handle = mysql_connect($server, $user_name, $password);

$db_found = mysql_select_db($database, $db_handle);

if ($db_found)
{
$SQL = "INSERT INTO members (id, fname, sname, email, password, gender) VALUES (NULL, $fname, $sname, $email, $pword, $gender);";
$result = mysql_query($SQL);

mysql_close($db_handle);

print "Thanks for joining us " . $fname;

print $fname;
print $sname;
print $email;
print $pword;
print $gender;
}
else
{
print "Database NOT Found";
mysql_close($db_handle);
}

?>