doesn't add to database

shawnhbk

ok so i fill out the information i submit i get no errors and i look in the database and it doesn't show anything being in it here is the script what's wrong

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<?
//only edit at the bottom of the page
include 'http://www.fuckcopz.com/txt/user.php';

// Define post fields into simple variables
$first = $_POST['first'];
$last = $_POST['last'];
$email = $_POST['email'];
$username = $_POST['username'];
$password = $_POST['password'];
$password2 = $_POST['password2'];
$gender = $_POST['gender'];
$hompage_url = $_POST['hompage_url'];
$location = $_POST['location'];
$bithdate = $_POST['month'] . $_POST['day'] . $_POST['year']; 
$info = $_POST['info'];

/* Let's strip some slashes in case the user entered
any escaped characters. */

$first = stripslashes($first);
$last = stripslashes($last);
$email = stripslashes($email);
$username = stripslashes($username);
$password = stripslashes($password);
$password2 = stripslashes($password2);
$gender = stripslashes($gender);
$hompage_url = stripslashes($hompage_url);
$location = stripslashes($location);
$birthdate = stripslashes($birthdate);
$info = stripslashes($info);


/* Do some error checking on the form posted fields */

if((!$email) || (!$username) || (!$password) || (!$password2)){
    echo 'You did not submit the following required information! <br />';

}
if(!$email){
    echo "Email Address is a required field. Please enter it below.<br />";
}
if(!$username){
    echo "Nickname is a required field. Please enter it below.<br />";
if(!$password){
    echo "Password is a required field. Please enter it below.<br />";
 if(!$password2){
    echo "You must enter password twice. Please enter it below.<br />";
}
include 'register.php'; // Show the form again!
/* End the error checking and if everything is ok, we'll move on to
 creating the user account */
exit(); // if the error checking has failed, we'll exit the script!
}

/* Let's do some checking and ensure that the user's email address or username
does not exist in the database */

$sql_email_check = mysql_query("SELECT email FROM author
            WHERE email='$email'");
$sql_username_check = mysql_query("SELECT username FROM author
            WHERE username='$username'");

$email_check = mysql_num_rows($sql_email_check);
$username_check = mysql_num_rows($sql_username_check);

if(($email_check > 0) || ($username_check > 0)){
    echo "Please fix the following errors: <br />";
    if($email_check > 0){
        echo "<strong>Your email address already exists in our database.<br />";
        unset($email);
    }
    if($username_check > 0){
        echo "The username you have selected has already been used by another member. 
		Please choose a different Username.<br />";
        unset($username);
    }
    include 'register.php'; // Show the form again!
    exit();  // exit the script so that we do not create this account!
}

//Everything has passed both error checks that we have done.
//It's time to create the account! */
//We'll generate a random password for the
//user and encrypt it, email it and then enter it into the db.




// Enter info into the Database.
$info2 = htmlspecialchars($info);
$sql = mysql_query("INSERT INTO author (first, last,
        email, username, password, info)
        VALUES('$first', '$last', '$email',
        '$username', '$db_password', '$info2', now())")
        or die (mysql_error());
if(!$sql){
    echo ('There has been an error creating your account. Please contact the webmaster');
} else {
    $userid = mysql_insert_id();
    // Let's mail the user
    //Change all text below to what YOU want
    $subject = "Your Bloody Nightmare account!";
    $message = "Dear $first_name $last_name,
    Thank you for registering at Bloody Nightmare, [url]http://www.vurtunetech.com/bloody/[/url]!

You are two steps away from logging in and playing the game.

To activate your account,
please click here: [url]http://www.fuckcopz.com/activate.php?id=[/url]$userid&code=$db_password

Once you activate your account, you will be able to login
with the following information:
Username: $username
Password: $password

Thanks!
Bloody Nightmare staff

This is an automated response, please do not reply!";

mail($email_address, $subject, $message,
//Make sure to alter the from fields
    "From: Vurtune Technologies<noreply@vurtunetech.com.com>\n
    X-Mailer: PHP/" . phpversion());
echo 'Your account information has been mailed to your email address!
Please check it and follow the directions!';
}}
?>

bradgrafelman

Make sure it's inserting; change this:

$sql = mysql_query("INSERT INTO author (first, last, 
        email, username, password, info) 
        VALUES('$first', '$last', '$email', 
        '$username', '$db_password', '$info2', now())") 
        or die (mysql_error());

to this:

$sql = mysql_query("INSERT INTO author (first, last, 
        email, username, password, info) 
        VALUES('$first', '$last', '$email', 
        '$username', '$db_password', '$info2', now())") 
        or die (mysql_error()); 

echo 'There were ' . mysql_affected_rows() . ' row(s) INSERTed.<br>';

shawnhbk

it still doesn't add it with no error message

bradgrafelman

The point of adding that bit of code was to see how many rows (if any) it claimed it had INSERT'ed.

After adding my code, paste the echo'd line that says "There were xx row(s)..."

Sxooter

DId you happen to notice that your insert query has more fields in the insert list than in the field list?

INSERT INTO author (
  first, -- 1
  last, -- 2
  email,  -- 3
  username,  -- 4
  password, -- 5
  info  --6
)
VALUES(
  '$first',  -- 1
  '$last',  -- 2
  '$email',  -- 3
  '$username',  -- 4
  '$db_password',  -- 5
  '$info2',  -- 6
  now()  -- 7
)

Now, why aren't you getting any useful error messages? I'm not sure about that.