See anything wrong?
Thanks in advance.
Code: Select all
<?PHP
$thismonth = $_POST[thismonth];
$thisday = $_POST[thisday];
$thisyear = $_POST[thisyear];
$employmentprog = $_POST[employment_chkbox];
$businessprog = $_POST[business_chkbox];
$certprog = $_POST[certification_chkbox];
$youthprog = $_POST[youth_chkbox];
$parentprog = $_POST[parent_chkbox];
$policyprog = $_POST[advocacy_chkbox];
$firstname = $_POST[employment_chkbox];
$middlename = $_POST[middlename];
$month = $_POST['birth_date'][M];
$day = $_POST['birth_date'][d]; // I *think* this is the right way to grab an element of an array???
$year = $_POST['birth_date'][Y];
$birthdate = $year.'-'.$month.'-'.$day;
$street = $_POST[street];
$city = $_POST[city];
$state = $_POST[state];
$postalcode = $_POST[postalcode];
$homephone = $_POST[homephone];
$otherphone = $_POST[otherphone];
$referral = $_POST[referral];
$contact = $_POST[contact];
$race = $_POST[race];
$otherrace = $_POST[otherrace];
$gender = $_POST[gender];
$registrationday = $thisyear.'-'.$thismonth.'-'.$thisday;
$DBhost = "www.usdm.org";
$DBuser = "jsdde";
$DBpass = "gsy";
$DBName = "ulem";
$table = "registration";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable toconnect to database");
@mysql_select_db("$DBName") or die("Unable to select database $DBName");
$sqlquery = "INSERT INTO registration (employmentprog, businessprog, certprog, youthprog, parentprog, policyprog, parentprog, policyprog, firstname, middlename, lastname, birthdate, street, city, state, postalcode, homephone, otherphone, referral, contact, race, otherrace, gender, regdate)
VALUES
($employmentprog, $businessprog, $certprog, $youthprog, $parentprog, $policyprog, $parentprog, $policyprog, $firstname, $middlename,$lastname, $birthdate, $street, $city, $state, $postalcode, $homephone, $otherphone, r$eferral, $contact, $race, $otherrace, $gender, $registrationday)";
$result = mysql_query($sqlquery);
?>Just a blank page comes up.
Thanks for your attentions...
J