Original Post
hi guys, im making a text-based mmorpg and im getting the following errors with this code Notice: Undefined variable: MONEY in c:\program files\easyphp1-7\www\v 0.0.1\register.php on line 107 Notice: Undefined variable: FANS in c:\program files\easyphp1-7\www\v 0.0.1\register.php on line 107 Erreur de syntaxe près de 'now())' à la ligne 2 here is my code: $info2 = htmlspecialchars($info); $sql = mysql_query("INSERT INTO users (first_name, last_name, email_address, username, password, info, signup_date) VALUES('$first_name', '$last_name', '$email_address', '$username', '$db_password', '$info2', now())") or die (mysql_error()); $money = 500; $fans = 10; $sql2 = mysql_query("INSERT INTO userstats (money, fans) VALUES('$MONEY', '$FANS' now())") or die (mysql_error()); if(!$sql){ echo 'There has been an error creating your account. Please contact the webmaster.'; } else if(!$sql2){ echo 'Please try again.'; } else { $userid = mysql_insert_id(); // Let's mail the user! $subject = "Your Membership at MyWebsite!"; $message = "Dear $first_name $last_name, Thank you for signing up at our website, http://v491400027/v%200.0.1/ You are two steps away from logging in and accessing our new game. To activate your membership, please click here: http://v491400027/v%200.0.1/activate.php?id=$userid&code=$db_password Once you activate your memebership, you will be able to login with the following information: Username: $username Password: $random_password Thanks! Alex Please do not reply!"; mail($email_address, $subject, $message, "From: Music MMORPG \nX-Mailer: PHP/" . phpversion()); echo 'Your membership information has been mailed to your email address! Please check it and follow the directions!'; } the email does not get sent, (yes i have SMTP and everything set-up), and the data only gets saved in the table "users", and not "userstats". thanks alex [Edited by - bigfooot on October 21, 2005 12:51:27 AM]