Hi:
I have just completed my multi-page register screen. When I get to the page where it gives a view of the information, everything views correctly. But when I go to submit the information into MySQL, three of the fields are not populated and cannot figure out why.
The information is put into hidden fields through each step. When you get to the last page to submit is when the info that isnt submitted until the last minute is then put into the form. The information that is not submitting are:
1) userpic
2) userpicalt
3) reg_date
Please advise if you can.
<form action="<? $PHP_SELF ?>" method="post">
<input type="hidden" name="username" value="<? echo "$username"; ?>">
<input type="hidden" name="password" value="<? echo "$password"; ?>">
<input type="hidden" name="password2" value="<? echo "$password2"; ?>">
<input type="hidden" name="fname" value="<? echo "$fname"; ?>">
<input type="hidden" name="sname" value="<? echo "$sname"; ?>">
<input type="hidden" name="emaila" value="<? echo "$emaila"; ?>">
<input type="hidden" name="country" value="<? echo "$country"; ?>">
<input type="hidden" name="age" value="<? echo "$age"; ?>">
<input type="hidden" name="iam" value="<? echo "$iam"; ?>">
<input type="hidden" name="gender" value="<? echo "$gender"; ?>">
<input type="hidden" name="school" value="<? echo "$school"; ?>">
<input type="hidden" name="userpic" value="<? echo "http://www.brailleschool.com/images/userpic/nopic.jpg"; ?>">
<input type="hidden" name="userpicalt" value="<? echo "This user has not uploaded a picture yet."; ?>">
<input type="hidden" name="status" value="<? echo "$status"; ?>">
<input type="hidden" name="interests" value="<? echo "$interests"; ?>">
<input type="hidden" name="aboutu" value="<? echo "$aboutu"; ?>">
<input type="hidden" name="whyjoin" value="<? echo "$whyjoin"; ?>">
<input type="hidden" name="hobbies" value="<? echo "$hobbies"; ?>">
<input type="hidden" name="newsletter" value="<? echo "$newsletter"; ?>">
<input type="hidden" name="account_active" value="<? echo "No"; ?>">
<input type="hidden" name="reg_date" value="<? $date=date('m-d-Y'); ?>">
<?
include("../../config.php");
$connection = mysql_connect("$server", "$db_user", "$db_pass");
$db = mysql_select_db("$database", $connection);
$query = "INSERT INTO logintest (`username`,`password`,`fname`,`sname`,`email`,`country`,`interests`,`age`,`iam`,`gender`,`school`,`status`,`aboutu`,`whyjoin`,`hobbies`, `userpic`, `userpicalt`, `newsletter`, `reg_date`) VALUES ('$username', '$password', '$fname','$sname', '$emaila', '$country', '$interests','$age', '$iam', '$gender', '$school', '$status', '$aboutu', '$whyjoin', '$hobbies', '$userpic', '$userpicalt', '$newsletter', '$reg_date')";
$result = mysql_query($query, $connection);
//// add administration information to the users contact address book start
$connection = mysql_connect("$server", "$db_user", "$db_pass");
$db = mysql_select_db("$database", $connection);
$query = "INSERT INTO contactbooktest (`username`,`contactuser`) VALUES ('$username', 'admin')";
$result = mysql_query($query, $connection);
$connection = mysql_connect("$server", "$db_user", "$db_pass");
$db = mysql_select_db("$database", $connection);
$query = "INSERT INTO contactbooktest (`username`,`contactuser`) VALUES ('$username', 'sweetsugar_56')";
$result = mysql_query($query, $connection);
$connection = mysql_connect("$server", "$db_user", "$db_pass");
$db = mysql_select_db("$database", $connection);
$query = "INSERT INTO contactbooktest (`username`,`contactuser`) VALUES ('$username', 'webmaster')";
$result = mysql_query($query, $connection);
$connection = mysql_connect("$server", "$db_user", "$db_pass");
$db = mysql_select_db("$database", $connection);
$query = "INSERT INTO contactbooktest (`username`,`contactuser`) VALUES ('$username', 'support')";
$result = mysql_query($query, $connection);
//// add administration information to the users contact address book end
echo "$lang[thanksregister]";
$ida= uniqid('message');
$ida2= uniqid('$ida');
$nr= uniqid($ida);
$date=date('m-d-Y H:i:s');
$connection = mysql_connect("$server", "$db_user", "$db_pass");
$db = mysql_select_db("$database", $connection);
$query = "SELECT * FROM usermessagestest";
$query = "INSERT INTO usermessagestest (`nomer`, `tombr`, `frommbr`, `date`, `title`, `message`, `new`) VALUES ('$nr', '$username', 'Admin', '$date', '$lang[adminwelcome]', 'Dear $fname $sname,<br><br>Thank you for joining Braille School!<br><br>We would like to inform you that your username <b><span class=errormsg>$username</span></b> $lang[adminwelcomemessage]', 'yes')";
$result = mysql_query($query, $connection);
mail("admin@brailleschool.com", "New Braille School User","Dear Paddy,\nThis is an automated message from the Braille School web site to inform you that $fname $sname registered for an account at Braille School. Here is the information that they submitted in regard to their account creation.
\n(M) Username: $username
(M) Password: $password
(M) Email Address: $emaila
(M) First Name: $fname
(O) Last Name: $sname
(M) Country: $country
(O) Interests: $interests
(M) Age: $age
(M) You Are: $iam
(M) Gender: $gender
(O) School: $school
(M) Marital Status: $status
(O) About You: $aboutu
(M) Why Join: $whyjoin
(O) Hobbies: $hobbies
(M) Receive Newsletter?: $newsletter
\nCordially,
Blindness Related Learning.", "From: Braille School Accounts <accounts@brailleschool.com>");
?>