61
Coding / Another PHP Problem
« on: May 15, 2007, 01:05:49 am »
I am building a members db, and when i try to add a user, it doesn't insert it into the db:
Code: [Select]
<? include $_SERVER['DOCUMENT_ROOT']."/black_site/layout /top.php"; ?>
<?
$nr = $_GET['nr'];
if($nr=='') {
?>
<form action="/black_site/register.php?nr=0" method="post">
Username: <input type="text" name="user"><br />
Password: <input type="password" name="pass"><br />
Email: <input type="text" name="email"><br />
<input type="submit" value="Go!">
</form>
<?
} else if($nr=='0') {
$user = $_POST['user'];
$pass = $_POST['pass'];
$email = $_POST['email'];
$result = mysql_query("SELECT (username) FROM users WHERE username='$user'");
if(mysql_num_rows($result)==1) {
print "Username is Taken";
} else {
mysql_query("INSERT INTO `users` (`username`,`password`,`email`,`class`) VALUES ('$user','$pass','$email','member')");
mysql_query("INSET INTO `user_pro` (`name`,`msn`,`yaim`,`icq`,`site`,`site_link`
,`date_born`,`age`,`class`,`position`) VALUES ('$user','N/A','N/A','N/A','N/A','N/A','N/A',
'N/A','Member','N/A')");
print "You Have Been Registered";
}
}
?>
<? include $_SERVER['DOCUMENT_ROOT']."/black_site/layout /bottum.php"; ?>