Ok.. when I go to register for an account.. it goes through ok.. but it adds nothing for each of the things!
<?php
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
$aim = $_POST['aim'];
$db = mysql_connect("localhost","root") or mysql_die ("Unable to Connect to Mysql.. please contact Brandon about this!");
mysql_select_db("members",$db);
//check to see username/email are already in the database
$sql = "SELECT username FROM users WHERE username='" .$username . " 'LIMIT 1";
$result = mysql_query($sql);
if(!($result = mysql_query($sql))) die(mysql_error());
if(mysql_num_rows($result) == 1) {
echo "The username, " .$username. ", that you selected has already been taken. Please choose another username."; }
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
$aim = $_POST['aim'];
$sql1 = "SELECT email FROM users WHERE email='" .$email . " 'LIMIT 1";
$result1 = mysql_query($sql1);
if(!($result1 = mysql_query($sql1))) die(mysql_error());
if(mysql_num_rows($result1) == 1) {
echo "The email, " .$email. ", that you selected has already been taken. Please use another e=mail address. If you lost your password please get a new one."; }
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
$aim = $_POST['aim'];
$sql2 = "INSERT INTO `users` (`username` , `password` , `aim` , `email` , `joined`) VALUES (username, password, aim, email, CURDATE( ))";
$result2 = mysql_query($sql2);
echo "Thanks for registering! You may now login!";
?>
Also.. if you put in the same email/username.. it still adds.. how do you make it so if the email/username is there.. it wont go on to $sql2 ?
