Posting values to a table
Posted: Tue Sep 22, 2009 9:35 pm
Hi Everyone, I have a working registration form but recently added 10 new fields to the table it posts to, consequently, what did look like this:
I have changed to look like this:
I refer to this part of my code as the error I get says "Parse error: syntax error, unexpected T_STRING in /var/www/vhosts/picfrisky.com/httpdocs/regform/register.php on line 260"
and Im not sure where Ive gone wrong, could someone advise me please?
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?