need some help

[Steve0101]

I am trying to work out a script so that when some body enters there info in a form I have made it will add it to the data base but it does not work and I have tried alot of things but still no luck here is the from code

<form method="POST" action="register.php">
<p align="center">
Thank you for wanting to be part of sim pet</p>
<p align="center">
Nickname<input type="text" name="nick_name" size="20"></p>
<p align="center">Password<input type="password" name="Password" size="20"></p>
<p align="center">Password again<input type="password" name="Password2" size="20"></p>
<p align="center">E-mail<input type="text" name="email" size="20"></p>
<p align="center">Real Name<input type="text" name="realname" size="20"></p>
<p align="center">Age<input type="text" name="age" size="20"></p>
<p align="center"><br>
<input type="submit" value="Register" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>




and then the php code on the next page


<?php
require_once ('C:/Program Files/Abyss Web Server/connect.php');

if ("SUBMIT" == $B1) {
$dbc = "INSERT INTO users " .
"nick_name='$nickname', " .
"password='$Password', " .
"email='$email', " .
"name='$realname', " .
"age='$age', " .
"registration_date=CURDATE()";
if (mysql_query($dbc)) {
echo("<P>You have been add to Sim Pet.</P>");
} else {
echo("<P>Error : " .
mysql_error() . "</P>");
}
}



mysql_close();

echo "Nick Name entered: $nickname";
echo "<br />Password entered: $Password\n\n";
echo "<br />Email entered: $email\n\n";
echo "<br />Your real name: $realname\n\n";
echo "<br />Your age: $age\n\n";
?>

I am very new to php and mysql so i am learning as i go any help on this would be great :lol:

[TRUSTAbyss]

Ok it looks as if the PHP code you where writing is from the old varibals.
Try the form again having Register Globals = On and tell us if it works.

A correct way to write a new varibal within php is

New Varibal: