Code: Select all
$sql4 = "INSERT INTO `users`
(`firstname`,`lastname`,`yob`,`mob`,`dob`,`email`,`username`,`password`,`gender`,`sexuality`,`city`,`postcode`,`country`,`date`)
VALUES ('".$firstname."','".$lastname."','".$yob."','".$mob."','".$dob."','".$email."','".$username."','".md5($password)."','".$gender."','".$sexuality."','".$city."','".$postcode."','".$country."','".$date."')";
$res4 = mysql_query($sql4) or die(mysql_error());
echo "Hello <b>".$username."</b> you have been registered!<b><br>Please wait while you are re-directed";Code: Select all
$sql4 = "INSERT INTO `users`
(`firstname`,`lastname`,`yob`,`mob`,`dob`,`email`,`username`,`password`,`gender`,`sexuality`,`city`,`postcode`,`country`,`date`,`userid`,`albumid`,`type`,`name`,`description`,`defaultimage`,`currentrate`,`imagedescription`,`count`,`cover`)
VALUES ('".$firstname."','".$lastname."','".$yob."','".$mob."','".$dob."','".$email."','".$username."','".md5($password)."','".$gender."','".$sexuality."','".$city."','".$postcode."','".$country."','".$date.",' ',' ',' ',' ',' ','0','0',' ','0','"images/nocover.jpg"')";
$res4 = mysql_query($sql4) or die(mysql_error());
echo "Hello <b>".$username."</b> you have been registered!<b><br>Please wait while you are re-directed";and Im not sure where Ive gone wrong, could someone advise me please?