Success!! Genious i cant beleive i didnt think of that !
The form
<form action=register.php method=post>
Username:<input name="username" size="30" autocomplete="off" value="" type="text" /><br /><br />
Password:<input name="password" size="30" type="password" /><br /><br />
First Name:<input name="firstname" size="30" type="text" /><br /><br />
Last Name:<input name="lastname" size="30" type="text" /><br /><br />
Email:<input name="email" size="30" type="text" /><br /><br />
Age:<input name="age" size="30" maxlength="2" /><br /><br />
<input type="submit" class="button" value="Register" />
<input type="reset" name="reset" value="Clear" />
</form>
--------------------------------------------------------
the register.php
<?php
include 'mysql-connect.php';
$username = $_POST['username'];
$password = $_POST['password'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$age = $_POST['age'];
$ip = $_SERVER['REMOTE_ADDR'];
$result = mysql_num_rows(mysql_query("SELECT * FROM wwd_users WHERE username='$username'"));
if($result == 1)
{
echo " <script>window.location=\"registration.php?success=0\"</script>";
}
else
{
mysql_query("INSERT INTO wwd_users (username, password, firstname, lastname, age, ip)
VALUES ('$username', '$password', '$firstname', '$lastname', '$age', '$ip')");
echo " <script>window.location=\"registration.php?success=1\"</script>";
}
?>
--------------------------------------------------------------------
Thanks again seems to work now