1,105,594 Community Members

HTML form won't UPDATE my database

Member Avatar
jdgieschen
Newbie Poster
20 posts since Jan 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Alright everybody! Here's a whopper for you. I've looked over this for the longest time and just can't figure it out. I want to update my database with the user's information when they save the html form. I'm guessing there's like a quotation mark or comma misplaced or something, and I've just had too much happy-juice, but... anyway, it works if I take out all the variables after "hs_prnt1". The SELECT query works all the time. It just won't UPDATE if I put the rest of those variables back in. Is the server at a query limit or something? Those tables, when put together, do obviously have a lot of rows in them... like 150 altogether. Please don't hate, but I'm gonna post the whole code here, since it may be necessary to figure this one out. I put some markers next to the variables that gives me problems. Here it is:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?php
session_start(); // Must start session first thing
if (!isset($_SESSION['id'])) { 
?>
</head>
<body>
I'm gonna light you up like a Christmas tree!!!
</body>
</html>
<?php
   exit(); 
}
include_once "db.php";
$id = $_SESSION['id'];
$toplinks = "";
$username = $_SESSION['username'];
$toplinks = '<h4>Hi, ' . $username . '! &bull; 
<a href="logout.php">Log Out</a></h4>';
if (isset($_POST['ln_st'])) {
    $ln_st = $_POST['ln_st'];
    $fn_st = $_POST['fn_st'];
    $pref_name_st = $_POST['pref_name_st'];
    $date_birth_st = $_POST['date_birth_st'];
    $city_birth_st = $_POST['city_birth_st'];
    $prov_birth_st = $_POST['prov_birth_st'];
    $country_birth_st = $_POST['country_birth_st'];
    $street_st = $_POST['street_st'];
    $building_st = $_POST['building_st'];
    $city_st = $_POST['city_st'];
    $cc_st = $_POST['cc_st'];
    $phone_st = $_POST['phone_st'];
    $qq_st = $_POST['qq_st'];
    $email_st = $_POST['email_st'];
    $marital_prnt = $_POST['marital_prnt'];
    $cur_school = $_POST['cur_school'];
    $cur_grade = $_POST['cur_grade'];
    $cur_years_in = $_POST['cur_years_in'];
    $cur_cc_cnsl = $_POST['cur_cc_cnsl'];
    $cur_phone_cnsl = $_POST['cur_phone_cnsl'];
    $cur_street = $_POST['cur_street'];
    $cur_building = $_POST['cur_building'];
    $cur_city = $_POST['cur_city'];
    $cur_ln_cnsl = $_POST['cur_ln_cnsl'];
    $cur_fn_cnsl = $_POST['cur_fn_cnsl'];
    $cur_title_cnsl = $_POST['cur_title_cnsl'];
    $cur_position_cnsl = $_POST['cur_position_cnsl'];
    $graduating_class = $_POST['graduating_class'];
    $gpa = $_POST['gpa'];
    $gpa_scale = $_POST['gpa_scale'];
    $gpa_weight = $_POST['gpa_weight'];
    $fmr_school = $_POST['fmr_school'];
    $fmr_years_in = $_POST['fmr_years_in'];
    $fmr_cc_cnsl = $_POST['fmr_cc_cnsl'];
    $fmr_phone_cnsl = $_POST['fmr_phone_cnsl'];
    $fmr_street = $_POST['fmr_street'];
    $fmr_building = $_POST['fmr_building'];
    $fmr_city = $_POST['fmr_city'];
    $fmr_ln_cnsl = $_POST['fmr_ln_cnsl'];
    $fmr_fn_cnsl = $_POST['fmr_fn_cnsl'];
    $fmr_title_cnsl = $_POST['fmr_title_cnsl'];
    $fmr_position_cnsl = $_POST['fmr_position_cnsl'];
    $date_test1 = $_POST['date_test1'];
    $score_test1 = $_POST['score_test1'];
    $v_test1 = $_POST['v_test1'];
    $m_test1 = $_POST['m_test1'];
    $w_test1 = $_POST['w_test1'];
    $date_test2 = $_POST['date_test2'];
    $score_test2 = $_POST['score_test2'];
    $v_test2 = $_POST['v_test2'];
    $m_test2 = $_POST['m_test2'];
    $w_test2 = $_POST['w_test2'];
    $date_test3 = $_POST['date_test3'];
    $score_test3 = $_POST['score_test3'];
    $v_test3 = $_POST['v_test3'];
    $m_test3 = $_POST['m_test3'];
    $w_test3 = $_POST['w_test3'];
    $test4 = $_POST['test4'];
    $date_test4 = $_POST['date_test4'];
    $score_test4 = $_POST['score_test4'];
    $test5 = $_POST['test5'];
    $date_test5 = $_POST['date_test5'];
    $score_test5 = $_POST['score_test5'];
    $test6 = $_POST['test6'];
    $date_test6 = $_POST['date_test6'];
    $score_test6 = $_POST['score_test6'];
    $test7 = $_POST['test7'];
    $date_test7 = $_POST['date_test7'];
    $score_test7 = $_POST['score_test7'];
    $c1f = $_POST['c1f'];
    $c1s = $_POST['c1s'];
    $c2f = $_POST['c2f'];
    $c2s = $_POST['c2s'];
    $c3f = $_POST['c3f'];
    $c3s = $_POST['c3s'];
    $c4f = $_POST['c4f'];
    $c4s = $_POST['c4s'];
    $c5f = $_POST['c5f'];
    $c5s = $_POST['c5s'];
    $c6f = $_POST['c6f'];
    $c6s = $_POST['c6s'];
    $c7f = $_POST['c7f'];
    $c7s = $_POST['c7s'];
    $c8f = $_POST['c8f'];
    $c8s = $_POST['c8s'];
    $c9f = $_POST['c9f'];
    $c9s = $_POST['c9s'];
    $c10f = $_POST['c10f'];
    $c10s = $_POST['c10s'];
    $c11f = $_POST['c11f'];
    $c11s = $_POST['c11s'];
    $c12f = $_POST['c12f'];
    $c12s = $_POST['c12s'];
    $c13f = $_POST['c13f'];
    $c13s = $_POST['c13s'];
    $c14f = $_POST['c14f'];
    $c14s = $_POST['c14s'];
    $ln_prnt1 = $_POST['ln_prnt1'];
    $fn_prnt1 = $_POST['fn_prnt1'];
    $title_prnt1 = $_POST['title_prnt1'];
    $relation_prnt1 = $_POST['relation_prnt1'];
    $date_birth_prnt1 = $_POST['date_birth_prnt1'];
    $city_birth_prnt1 = $_POST['city_birth_prnt1'];
    $prov_birth_prnt1 = $_POST['prov_birth_prnt1'];
    $country_birth_prnt1 = $_POST['country_birth_prnt1'];
    $street_prnt1 = $_POST['street_prnt1'];
    $building_prnt1 = $_POST['building_prnt1'];
    $city_prnt1 = $_POST['city_prnt1'];
    $guardian_prnt1 = $_POST['guardian_prnt1'];
    $cc_prnt1 = $_POST['cc_prnt1'];
    $phone_prnt1 = $_POST['phone_prnt1'];
    $email_prnt1 = $_POST['email_prnt1'];
    $hs_prnt1 = $_POST['hs_prnt1']; //-------------------------------------------------------------------------
    $hs_add_prnt1 = $_POST['hs_add_prnt1'];//-----------------------------------------------------------
    $col_prnt1 = $_POST['col_prnt1']; //---------------------------------------------------------------------
    $col_deg_prnt1 = $_POST['col_deg_prnt1'];
    $col_year_prnt1 = $_POST['col_year_prnt1'];
    $gr_prnt1 = $_POST['gr_prnt1'];
    $gr_deg_prnt1 = $_POST['gr_deg_prnt1'];
    $gr_year_prnt1 = $_POST['gr_year_prnt1'];
    $work_add_prnt1 = $_POST['work_add_prnt1'];
    $work_position_prnt1 = $_POST['work_position_prnt1'];
    $work_cc_prnt1 = $_POST['work_cc_prnt1'];
    $work_phone_prnt1 = $_POST['work_phone_prnt1'];
    $work_street_prnt1 = $_POST['work_street_prnt1'];
    $work_building_prnt1 = $_POST['work_building_prnt1'];
    $work_city_prnt1 = $_POST['work_city_prnt1'];
    $ln_prnt2 = $_POST['ln_prnt2'];
    $fn_prnt2 = $_POST['fn_prnt2'];
    $title_prnt2 = $_POST['title_prnt2'];
    $relation_prnt2 = $_POST['relation_prnt2'];
    $date_birth_prnt2 = $_POST['date_birth_prnt2'];
    $city_birth_prnt2 = $_POST['city_birth_prnt2'];
    $prov_birth_prnt2 = $_POST['prov_birth_prnt2'];
    $country_birth_prnt2 = $_POST['country_birth_prnt2'];
    $street_prnt2 = $_POST['street_prnt2'];
    $building_prnt2 = $_POST['building_prnt2'];
    $city_prnt2 = $_POST['city_prnt2'];
    $guardian_prnt2 = $_POST['guardian_prnt2'];
    $cc_prnt2 = $_POST['cc_prnt2'];
    $phone_prnt2 = $_POST['phone_prnt2'];
    $email_prnt2 = $_POST['email_prnt2'];
    $hs_prnt2 = $_POST['hs_prnt2'];
    $hs_add_prnt2 = $_POST['hs_add_prnt2'];
    $col_prnt2 = $_POST['col_prnt2'];
    $col_deg_prnt2 = $_POST['col_deg_prnt2'];
    $col_year_prnt2 = $_POST['col_year_prnt2'];
    $gr_prnt2 = $_POST['gr_prnt2'];
    $gr_deg_prnt2 = $_POST['gr_deg_prnt2'];
    $gr_year_prnt2 = $_POST['gr_year_prnt2'];
    $work_add_prnt2 = $_POST['work_add_prnt2'];
    $work_position_prnt2 = $_POST['work_position_prnt2'];
    $work_cc_prnt2 = $_POST['work_cc_prnt2'];
    $work_phone_prnt2 = $_POST['work_phone_prnt2'];
    $work_street_prnt2 = $_POST['work_street_prnt2'];
    $work_building_prnt2 = $_POST['work_building_prnt2'];
    $work_city_prnt2 = $_POST['work_city_prnt2'];


$sql = mysql_query("
UPDATE sts_psnl AS a
INNER JOIN sts_ed AS b
INNER JOIN sts_tst AS c
INNER JOIN sts_crs AS d
INNER JOIN sts_prnt1 AS e
INNER JOIN sts_prnt2 AS f 
ON a.id=b.id
and b.id=c.id
and c.id=d.id
and d.id=e.id 
SET 
a.ln_st='$ln_st',
a.fn_st='$fn_st', 
a.pref_name_st='$pref_name_st',
a.date_birth_st = '$date_birth_st',
a.city_birth_st = '$city_birth_st',
a.prov_birth_st = '$prov_birth_st',
a.country_birth_st = '$country_birth_st',
a.street_st = '$street_st',
a.building_st = '$building_st',
a.city_st = '$city_st',
a.cc_st = '$cc_st',
a.phone_st = '$phone_st',
a.qq_st = '$qq_st',
a.email_st = '$email_st',
a.marital_prnt = '$marital_prnt',
b.cur_school = '$cur_school',
b.cur_grade = '$cur_grade',
b.cur_years_in = '$cur_years_in',
b.cur_cc_cnsl = '$cur_cc_cnsl',
b.cur_phone_cnsl = '$cur_phone_cnsl',
b.cur_street = '$cur_street',
b.cur_building = '$cur_building',
b.cur_city = '$cur_city',
b.cur_ln_cnsl = '$cur_ln_cnsl',
b.cur_fn_cnsl = '$cur_fn_cnsl',
b.cur_title_cnsl = '$cur_title_cnsl',
b.cur_position_cnsl = '$cur_position_cnsl',
b.graduating_class = '$graduating_class',
b.gpa = '$gpa',
b.gpa_scale = '$gpa_scale',
b.gpa_weight = '$gpa_weight',
b.fmr_school = '$fmr_school',
b.fmr_years_in = '$fmr_years_in',
b.fmr_cc_cnsl = '$fmr_cc_cnsl',
b.fmr_phone_cnsl = '$fmr_phone_cnsl',
b.fmr_street = '$fmr_street',
b.fmr_building = '$fmr_building',
b.fmr_city = '$fmr_city',
b.fmr_ln_cnsl = '$fmr_ln_cnsl',
b.fmr_fn_cnsl = '$fmr_fn_cnsl',
b.fmr_title_cnsl = '$fmr_title_cnsl',
b.fmr_position_cnsl = '$fmr_position_cnsl',
c.date_test1 = '$date_test1',
c.score_test1 = '$score_test1',
c.v_test1 = '$v_test1',
c.m_test1 = '$m_test1',
c.w_test1 = '$w_test1',
c.date_test2 = '$date_test2',
c.score_test2 = '$score_test2',
c.v_test2 = '$v_test2',
c.m_test2 = '$m_test2',
c.w_test2 = '$w_test2',
c.date_test3 = '$date_test3',
c.score_test3 = '$score_test3',
c.v_test3 = '$v_test3',
c.m_test3 = '$m_test3',
c.w_test3 = '$w_test3',
c.test4 = '$test4',
c.date_test4 = '$date_test4',
c.score_test4 = '$score_test4',
c.test5 = '$test5',
c.date_test5 = '$date_test5',
c.score_test5 = '$score_test5',
c.test6 = '$test6',
c.date_test6 = '$date_test6',
c.score_test6 = '$score_test6',
c.test7 = '$test7',
c.date_test7 = '$date_test7',
c.score_test7 = '$score_test7',
d.c1f = '$c1f',
d.c1s = '$c1s',
d.c2f = '$c2f',
d.c2s = '$c2s',
d.c3f = '$c3f',
d.c3s = '$c3s',
d.c4f = '$c4f',
d.c4s = '$c4s',
d.c5f = '$c5f',
d.c5s = '$c5s',
d.c6f = '$c6f',
d.c6s = '$c6s',
d.c7f = '$c7f',
d.c7s = '$c7s',
d.c8f = '$c8f',
d.c8s = '$c8s',
d.c9f = '$c9f',
d.c9s = '$c9s',
d.c10f = '$c10f',
d.c10s = '$c10s',
d.c11f = '$c11f',
d.c11s = '$c11s',
d.c12f = '$c12f',
d.c12s = '$c12s',
d.c13f = '$c13f',
d.c13s = '$c13s',
d.c14f = '$c14f',
d.c14s = '$c14s',
e.ln_prnt1 = '$ln_prnt1',
e.fn_prnt1 = '$fn_prnt1',
e.title_prnt1 = '$title_prnt1',
e.relation_prnt1 = '$relation_prnt1',
e.date_birth_prnt1 = '$date_birth_prnt1',
e.city_birth_prnt1 = '$city_birth_prnt1',
e.prov_birth_prnt1 = '$prov_birth_prnt1',
e.country_birth_prnt1 = '$country_birth_prnt1',
e.street_prnt1 = '$street_prnt1',
e.building_prnt1 = '$building_prnt1',
e.city_prnt1 = '$city_prnt1',
e.guardian_prnt1 = '$guardian_prnt1',
e.cc_prnt1 = '$cc_prnt1',
e.phone_prnt1 = '$phone_prnt1',
e.email_prnt1 = '$email_prnt1',
e.hs_prnt1 = '$hs_prnt1',//------------------------------------------------------------------------------------
e.hs_add_prnt1 = '$hs_add_prnt1',//---------------------------------------------------------------------------
e.col_prnt1 = '$col_prnt1',//----------------------------------------------------------------------------------
e.col_deg_prnt1 = '$col_deg_prnt1',
e.$col_year_prnt1 = '$col_year_prnt1',
e.gr_prnt1 = '$gr_prnt1',
e.gr_deg_prnt1 = '$gr_deg_prnt1',
e.gr_year_prnt1 = '$gr_year_prnt1',
e.work_add_prnt1 = '$work_add_prnt1',
e.work_position_prnt1 = '$work_position_prnt1',
e.work_cc_prnt1 = '$work_cc_prnt1',
e.work_phone_prnt1 = '$work_phone_prnt1',
e.work_street_prnt1 = '$work_street_prnt1',
e.work_building_prnt1 = '$work_building_prnt1',
e.work_city_prnt1 = '$work_city_prnt1',
f.ln_prnt2 = '$ln_prnt2',
f.fn_prnt2 = '$fn_prnt2',
f.title_prnt2 = '$title_prnt2',
f.relation_prnt2 = '$relation_prnt2',
f.date_birth_prnt2 = '$date_birth_prnt2',
f.city_birth_prnt2 = '$city_birth_prnt2',
f.prov_birth_prnt2 = '$prov_birth_prnt2',
f.country_birth_prnt2 = '$country_birth_prnt2',
f.street_prnt2 = '$street_prnt2',
f.building_prnt2 = '$building_prnt2',
f.city_prnt2 = '$city_prnt2',
f.guardian_prnt2 = '$guardian_prnt2',
f.cc_prnt2 = '$cc_prnt2',
f.phone_prnt2 = '$phone_prnt2',
f.email_prnt2 = '$email_prnt2',
f.hs_prnt2 = '$hs_prnt2',
f.hs_add_prnt2 = '$hs_add_prnt2',
f.col_prnt2 = '$col_prnt2',
f.col_deg_prnt2 = '$col_deg_prnt2',
f.$col_year_prnt2 = '$col_year_prnt2',
f.gr_prnt2 = '$gr_prnt2',
f.gr_deg_prnt2 = '$gr_deg_prnt2',
f.gr_year_prnt2 = '$gr_year_prnt2',
f.work_add_prnt2 = '$work_add_prnt2',
f.work_position_prnt2 = '$work_position_prnt2',
f.work_cc_prnt2 = '$work_cc_prnt2',
f.work_phone_prnt2 = '$work_phone_prnt2',
f.work_street_prnt2 = '$work_street_prnt2',
f.work_building_prnt2 = '$work_building_prnt2',
f.work_city_prnt2 = '$work_city_prnt2' 
WHERE a.id='$id'");
}// close if post
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM sts_psnl AS a INNER JOIN sts_ed AS b INNER JOIN sts_tst AS c INNER JOIN sts_crs AS d INNER JOIN sts_prnt1 AS e INNER JOIN sts_prnt2 AS f WHERE a.id='$id' and b.id='$id' and c.id='$id' and d.id='$id' and e.id='$id' and f.id='$id' LIMIT 1");
while($row = mysql_fetch_array($sql)){
    $ln_st = $row['ln_st'];
    $fn_st = $row['fn_st'];
    $pref_name_st = $row['pref_name_st'];
    $date_birth_st = $row['date_birth_st'];
    $city_birth_st = $row['city_birth_st'];
    $prov_birth_st = $row['prov_birth_st'];
    $country_birth_st = $row['country_birth_st'];
    $street_st = $row['street_st'];
    $building_st = $row['building_st'];
    $city_st = $row['city_st'];
    $cc_st = $row['cc_st'];
    $phone_st = $row['phone_st'];
    $qq_st = $row['qq_st'];
    $email_st = $row['email_st'];
    $marital_prnt = $row['marital_prnt'];
    $cur_school = $row['cur_school'];
    $cur_grade = $row['cur_grade'];
    $cur_years_in = $row['cur_years_in'];
    $cur_cc_cnsl = $row['cur_cc_cnsl'];
    $cur_phone_cnsl = $row['cur_phone_cnsl'];
    $cur_street = $row['cur_street'];
    $cur_building = $row['cur_building'];
    $cur_city = $row['cur_city'];
    $cur_ln_cnsl = $row['cur_ln_cnsl'];
    $cur_fn_cnsl = $row['cur_fn_cnsl'];
    $cur_title_cnsl = $row['cur_title_cnsl'];
    $cur_position_cnsl = $row['cur_position_cnsl'];
    $graduating_class = $row['graduating_class'];
    $gpa = $row['gpa'];
    $gpa_scale = $row['gpa_scale'];
    $gpa_weight = $row['gpa_weight'];
    $fmr_school = $row['fmr_school'];
    $fmr_years_in = $row['fmr_years_in'];
    $fmr_cc_cnsl = $row['fmr_cc_cnsl'];
    $fmr_phone_cnsl = $row['fmr_phone_cnsl'];
    $fmr_street = $row['fmr_street'];
    $fmr_building = $row['fmr_building'];
    $fmr_city = $row['fmr_city'];
    $fmr_ln_cnsl = $row['fmr_ln_cnsl'];
    $fmr_fn_cnsl = $row['fmr_fn_cnsl'];
    $fmr_title_cnsl = $row['fmr_title_cnsl'];
    $fmr_position_cnsl = $row['fmr_position_cnsl'];
    $date_test1 = $row['date_test1'];
    $score_test1 = $row['score_test1'];
    $v_test1 = $row['v_test1'];
    $m_test1 = $row['m_test1'];
    $w_test1 = $row['w_test1'];
    $date_test2 = $row['date_test2'];
    $score_test2 = $row['score_test2'];
    $v_test2 = $row['v_test2'];
    $m_test2 = $row['m_test2'];
    $w_test2 = $row['w_test2'];
    $date_test3 = $row['date_test3'];
    $score_test3 = $row['score_test3'];
    $v_test3 = $row['v_test3'];
    $m_test3 = $row['m_test3'];
    $w_test3 = $row['w_test3'];
    $test4 = $row['test4'];
    $date_test4 = $row['date_test4'];
    $score_test4 = $row['score_test4'];
    $test5 = $row['test5'];
    $date_test5 = $row['date_test5'];
    $score_test5 = $row['score_test5'];
    $test6 = $row['test6'];
    $date_test6 = $row['date_test6'];
    $score_test6 = $row['score_test6'];
    $test7 = $row['test7'];
    $date_test7 = $row['date_test7'];
    $score_test7 = $row['score_test7'];
    $c1f = $row['c1f'];
    $c1s = $row['c1s'];
    $c2f = $row['c2f'];
    $c2s = $row['c2s'];
    $c3f = $row['c3f'];
    $c3s = $row['c3s'];
    $c4f = $row['c4f'];
    $c4s = $row['c4s'];
    $c5f = $row['c5f'];
    $c5s = $row['c5s'];
    $c6f = $row['c6f'];
    $c6s = $row['c6s'];
    $c7f = $row['c7f'];
    $c7s = $row['c7s'];
    $c8f = $row['c8f'];
    $c8s = $row['c8s'];
    $c9f = $row['c9f'];
    $c9s = $row['c9s'];
    $c10f = $row['c10f'];
    $c10s = $row['c10s'];
    $c11f = $row['c11f'];
    $c11s = $row['c11s'];
    $c12f = $row['c12f'];
    $c12s = $row['c12s'];
    $c13f = $row['c13f'];
    $c13s = $row['c13s'];
    $c14f = $row['c14f'];
    $c14s = $row['c14s'];
    $ln_prnt1 = $row['ln_prnt1'];
    $fn_prnt1 = $row['fn_prnt1'];
    $title_prnt1 = $row['title_prnt1'];
    $relation_prnt1 = $row['relation_prnt1'];
    $date_birth_prnt1 = $row['date_birth_prnt1'];
    $city_birth_prnt1 = $row['city_birth_prnt1'];
    $prov_birth_prnt1 = $row['prov_birth_prnt1'];
    $country_birth_prnt1 = $row['country_birth_prnt1'];
    $street_prnt1 = $row['street_prnt1'];
    $building_prnt1 = $row['building_prnt1'];
    $city_prnt1 = $row['city_prnt1'];
    $guardian_prnt1 = $row['guardian_prnt1'];
    $cc_prnt1 = $row['cc_prnt1'];
    $phone_prnt1 = $row['phone_prnt1'];
    $email_prnt1 = $row['email_prnt1'];
    $hs_prnt1 = $row['hs_prnt1'];
    $hs_add_prnt1 = $row['hs_add_prnt1'];
    $col_prnt1 = $row['col_prnt1'];
    $col_deg_prnt1 = $row['col_deg_prnt1'];
    $col_year_prnt1 = $row['col_year_prnt1'];
    $gr_prnt1 = $row['gr_prnt1'];
    $gr_deg_prnt1 = $row['gr_deg_prnt1'];
    $gr_year_prnt1 = $row['gr_year_prnt1'];
    $work_add_prnt1 = $row['work_add_prnt1'];
    $work_position_prnt1 = $row['work_position_prnt1'];
    $work_cc_prnt1 = $row['work_cc_prnt1'];
    $work_phone_prnt1 = $row['work_phone_prnt1'];
    $work_street_prnt1 = $row['work_street_prnt1'];
    $work_building_prnt1 = $row['work_building_prnt1'];
    $work_city_prnt1 = $row['work_city_prnt1'];
    $ln_prnt2 = $row['ln_prnt2'];
    $fn_prnt2 = $row['fn_prnt2'];
    $title_prnt2 = $row['title_prnt2'];
    $relation_prnt2 = $row['relation_prnt2'];
    $date_birth_prnt2 = $row['date_birth_prnt2'];
    $city_birth_prnt2 = $row['city_birth_prnt2'];
    $prov_birth_prnt2 = $row['prov_birth_prnt2'];
    $country_birth_prnt2 = $row['country_birth_prnt2'];
    $street_prnt2 = $row['street_prnt2'];
    $building_prnt2 = $row['building_prnt2'];
    $city_prnt2 = $row['city_prnt2'];
    $guardian_prnt2 = $row['guardian_prnt2'];
    $cc_prnt2 = $row['cc_prnt2'];
    $phone_prnt2 = $row['phone_prnt2'];
    $email_prnt2 = $row['email_prnt2'];
    $hs_prnt2 = $row['hs_prnt2'];//---------------------------------------------------------------------------
    $hs_add_prnt2 = $row['hs_add_prnt2'];//-------------------------------------------------------------------
    $col_prnt2 = $row['col_prnt2'];//---------------------------------------------------------------------------
    $col_deg_prnt2 = $row['col_deg_prnt2'];
    $col_year_prnt2 = $row['col_year_prnt2'];
    $gr_prnt2 = $row['gr_prnt2'];
    $gr_deg_prnt2 = $row['gr_deg_prnt2'];
    $gr_year_prnt2 = $row['gr_year_prnt2'];
    $work_add_prnt2 = $row['work_add_prnt2'];
    $work_position_prnt2 = $row['work_position_prnt2'];
    $work_cc_prnt2 = $row['work_cc_prnt2'];
    $work_phone_prnt2 = $row['work_phone_prnt2'];
    $work_street_prnt2 = $row['work_street_prnt2'];
    $work_building_prnt2 = $row['work_building_prnt2'];
    $work_city_prnt2 = $row['work_city_prnt2'];
}
?>
<link rel="stylesheet" type="text/css" href="css/styles.css" />
<link rel="stylesheet" type="text/css" href="css/form.css" />
<script type="text/javascript" src="js/jquery-1.7.1.min.js"></script>
<script type="text/javascript" src="js/formToWizard.js"></script>
<script type="text/javascript">
    $(document).ready(function(){
        $("#SignupForm").formToWizard({ submitButton: 'SaveAccount' })
    });
</script>
</head>
<body>
  <div style="background:#999; height:2000px; width:150px; float:left;">
    <img src="images/logo-sidebar.png" style="position:absolute;" />
  </div>
  <div style="position:relative; height:2000px; width:650px; background:#fff; float:left;">
    <div style="position:absolute; left: 8px; top: 6px;">
      <?php include_once ("lib/menu.php");?>
    </div>
    <div style="position:absolute; left: 409px; top: 6px;">
      <div id="menu">
        <ul>
          <li><a href="cn/test-app.php">中文</a></li>
        </ul>
        <div class="clear"></div>
      </div>
    </div>
    <div style="position:absolute; left: 500px; top: 6px; width:200px;">
      <?php echo "$toplinks"; ?>
    </div>
    <div style="position:absolute; left: 40px; top: 35px; height:55px; width:500px;"></div>
    <div id="content" style="width:720px; position:absolute; left: 40px; top: 90px; text-align:justify;">
      <h3>test-app</h3>
      <form id="SignupForm" action="test-app.php" method="POST">
        <fieldset>
          <legend>Personal Info</legend>
          <div id="form-el">
            <p>Last (Family) Name: <input name="ln_st" type="text" value="<?php echo "$ln_st"; ?>" style="width:80px;" placeholder="Chen" /></p>
            <p style="left:230px;">First (Given) Name: <input name="fn_st" type="text" value="<?php echo "$fn_st"; ?>" style="width:120px;" placeholder="Tingting" /></p>
            <p style="left:495px;">Preferred Name: <input name="pref_name_st" type="text" value="<?php echo "$pref_name_st"; ?>" style="width:120px;" placeholder="Tina"/></p><br /><br />
            <p>Birth Date: <input name="date_birth_st" type="text" value="<?php echo "$date_birth_st"; ?>" style="width:80px;" placeholder="dd/mm/yyyy"/></p>
            <p style="left:160px;">Birth Place: <input name="city_birth_st" type="text" value="<?php echo "$city_birth_st"; ?>" style="width:120px;" placeholder="Hangzhou"/> <input name="prov_birth_st" type="text" value="<?php echo "$prov_birth_st"; ?>" style="width:110px;" placeholder="Zhejiang"/> <input name="country_birth_st" type="text" value="<?php echo "$country_birth_st"; ?>" style="width:110px;" placeholder="China"/></p>
            <p style="left:600px;"><input id="student-male" name="student-gender" type="radio"/> Male</p>
            <p style="left:655px;"><input id="student-female" name="student-gender" type="radio"/> Female</p><br /><br />
            <p>Address: <input name="street_st" type="text" value="<?php echo "$street_st"; ?>" style="width:210px;" placeholder="225 Quankou Road"/> <input name="building_st" id="building_st" type="text" value="<?php echo "$building_st"; ?>" style="width:210px;" placeholder="Building 12, Apartment 302"/> <input name="city_st" type="text" value="<?php echo "$city_st"; ?>" style="width:220px;" placeholder="Wenling, Zhejiang 317500"/> </p><br /><br />
            <p>Phone Number: <input name="cc_st" type="text" value="<?php echo "$cc_st"; ?>" style="width:20px;" placeholder="86"/> <input name="phone_st" type="text" value="<?php echo "$phone_st"; ?>" style="width:90px;" placeholder="18651751751"/></p>
            <p style="left:230px">QQ Number: <input name="qq_st" type="text" value="<?php echo "$qq_st"; ?>" style="width:120px;" placeholder="1956158954"/></p>
            <p style="left:450px;">Email: <input name="email_st" type="text" value="<?php echo "$email_st"; ?>" style="width:220px;" placeholder="go2america@yahoo.com"/></p><br /><br />
            <p>Parent's Marital Status (relative to each other): 
              <select name="marital_prnt">
                <option value="<?php echo "$marital_prnt"; ?>"><?php echo "$marital_prnt"; ?></option>
                <option value="Married">Married</option>
                <option value="Divorced">Divorced</option>
                <option value="Separated">Separated</option>
                <option value="Widowed">Widowed</option>
                <option value="Unmarried">Unmarried</option>
              </select>
            </p><br /><br />
            <input id="SaveAccount" type="submit" value="Save" style="position:absolute; left:300px;" />
          </div>
        </fieldset>
        <fieldset>
          <legend>Education</legend>
          <div id="form-el">
            <p>Current School: <input name="cur_school" type="text" value="<?php echo "$cur_school"; ?>" style="width:300px;" placeholder="Taizhou No.1 Senior High School"/></p>
            <p style="left:420px;">Current Grade:  
              <select name="cur_grade" style="width:40px;">
                <option value="<?php echo "$cur_grade"; ?>"><?php echo "$cur_grade"; ?></option>
                <option value="12">12</option>
              </select>
            </p>
            <p style="left:580px;">Years Attended:
              <select name="cur_years_in" style="width:40px;">
                <option value="<?php echo "$cur_years_in"; ?>"><?php echo "$cur_years_in"; ?></option>
                <option value="1">1</option>
                <option value="2">2</option>
                <option value="3">3</option>
                <option value="4">4</option>
              </select>
            </p><br /><br />
            <p>Type of School: &nbsp;&nbsp;&nbsp;<input name="cur_public" type="checkbox" /> Public &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="cur_private" type="checkbox"/> Private&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="cur_boarding" type="checkbox"/> Boarding &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="cur_day" type="checkbox"/> Day</p>
            <p style="left:459px;">Phone Number: <input name="cur_cc_cnsl" type="text" value="<?php echo "$cur_cc_cnsl"; ?>" style="width:30px;" placeholder="86"/> <input name="cur_phone_cnsl" type="text" value="<?php echo "$cur_phone_cnsl"; ?>" style="width:120px;" placeholder="18651751751"/></p><br /><br />
            <p>Address: <input name="cur_street" type="text" value="<?php echo "$cur_street"; ?>" style="width:210px;" placeholder="225 Quankou Road"/> <input name="cur_building" type="text" value="<?php echo "$cur_building"; ?>" style="width:210px;" placeholder="Building 12, Apartment 302"/> <input name="cur_city" type="text" value="<?php echo "$cur_city"; ?>" style="width:220px;" placeholder="Wenling, Zhejiang 317500"/> </p><br /><br />
            <p>Counselor's Name: <input name="cur_ln_cnsl" type="text" value="<?php echo "$cur_ln_cnsl"; ?>" style="width:80px;" placeholder="Liu"/> <input name="cur_fn_cnsl" type="text" value="<?php echo "$cur_fn_cnsl"; ?>" style="width:120px;" placeholder="Bangbang"/></p>
            <p style="left:387px;">Title:
              <select name="cur_title_cnsl" style="width:60px;">
                <option value="<?php echo "$cur_title_cnsl"; ?>"><?php echo "$cur_title_cnsl"; ?></option>
                <option value="Mr.">Mr.</option>
                <option value="Ms.">Ms.</option>
              </select>
            </p>
            <p style="left:504px;">Position: <input name="cur_position_cnsl" type="text" value="<?php echo "$cur_position_cnsl"; ?>" style="width:150px;" placeholder="principal"/></p><br /><br />
            <p>Graduating Class Size: <input name="graduating_class" name="graduating_class" type="text" value="<?php echo "$graduating_class"; ?>" style="width:50px;" placeholder="720"/></p>
            <p style="left:200px;">Cumulative GPA: <input name="gpa" type="text" value="<?php echo "$gpa"; ?>" style="width:50px;" placeholder="3.67"/></p>
            <p style="left:370px;">GPA Scale: <input name="gpa_scale" type="text" value="<?php echo "$gpa_scale"; ?>" style="width:50px;" placeholder="4.0"/></p>
            <p style="left:500px;">GPA Weighting: <input name="gpa_weight" type="text" value="<?php echo "$gpa_weight"; ?>" style="width:116px;" placeholder="none"/></p><br /><br />
            <hr size="5" width="710" align="left" noshade><br />
            <p>Former School: <input name="fmr_school" type="text" value="<?php echo "$fmr_school"; ?>" style="width:300px;" placeholder="Taizhou No.1 Senior High School"/></p>
            <p style="left:582px;">Years Attended:
              <select name="fmr_years_in" style="width:40px;">
                <option value="<?php echo "$fmr_years_in"; ?>"><?php echo "$fmr_years_in"; ?></option>
                <option value="1">1</option>
                <option value="2">2</option>
                <option value="3">3</option>
                <option value="4">4</option>
              </select>
            </p><br /><br />
            <p>Type of School: &nbsp;&nbsp;&nbsp;<input name="fmr_public" type="checkbox"/> Public &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="fmr_private" type="checkbox"/> Private&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="fmr_boarding" type="checkbox"/> Boarding &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="fmr_day" type="checkbox"/> Day</p>
            <p style="left:459px;">Phone Number: <input name="fmr_cc_cnsl" type="text" value="<?php echo "$fmr_cc_cnsl"; ?>" style="width:30px;" placeholder="86"/> <input name="fmr_phone_cnsl" type="text" value="<?php echo "$fmr_phone_cnsl"; ?>" style="width:120px;" placeholder="18651751751"/></p><br /><br />
            <p>Address: <input name="fmr_street" type="text" value="<?php echo "$fmr_street"; ?>" style="width:210px;" placeholder="225 Quankou Road"/> <input name="fmr_building" type="text" value="<?php echo "$fmr_building"; ?>" style="width:210px;" placeholder="Building 12, Apartment 302"/> <input name="fmr_city" type="text" value="<?php echo "$fmr_city"; ?>" style="width:220px;" placeholder="Wenling, Zhejiang 317500"/> </p><br /><br />
            <p>Counselor's Name: <input name="fmr_ln_cnsl" type="text" value="<?php echo "$fmr_ln_cnsl"; ?>" style="width:80px;" placeholder="Liu"/> <input name="fmr_fn_cnsl" type="text" value="<?php echo "$fmr_fn_cnsl"; ?>" style="width:120px;" placeholder="Bangbang"/></p>
            <p style="left:387px;">Title:
              <select name="fmr_title_cnsl" style="width:60px;">
                <option value="<?php echo "$fmr_title_cnsl"; ?>"><?php echo "$fmr_title_cnsl"; ?></option>
                <option value="Mr.">Mr.</option>
                <option value="Ms.">Ms.</option>
              </select>
            </p>
            <p style="left:504px;">Position: <input name="fmr_position_cnsl" type="text" value="<?php echo "$fmr_position_cnsl"; ?>" style="width:150px;" placeholder="principal"/></p><br /><br />
            <input id="SaveAccount" type="submit" value="Save" style="position:absolute; left:300px;" />
          </div>
        </fieldset>
        <fieldset>
          <legend>Testing</legend>
          <div id="form-el">
            <h4>Please fill out the following spaces with information about your grades and the tests you have taken or will take.</h4><br /><br />
            <h4 style="left:40px;">Test</h4><h4 style="left:150px;">Date</h4><h4 style="left:235px;">Score</h4><h4 style="left:400px;">Verbal</h4><h4 style="left:523px;">Math</h4><h4 style="left:632px;">Writing</h4><br /><br />
            <p style="left:30px;"><input name="test1" type="checkbox"/> SAT</p><p style="left:130px;"><input name="date_test1" type="text" value="<?php echo "$date_test1"; ?>" style="width:80px;" placeholder="dd/mm/yyyy"/></p><p style="left:220px;"><input name="score_test1" type="text" value="<?php echo "$score_test1"; ?>" style="width:80px;" placeholder="1950"/></p><p style="left:387px;"><input name="v_test1" type="text" value="<?php echo "$v_test1"; ?>" style="width:80px;" placeholder="650"/></p><p style="left:504px;"><input name="m_test1" type="text" value="<?php echo "$m_test1"; ?>" style="width:80px;" placeholder="650"/></p><p style="left:622px;"><input name="w_test1" type="text" value="<?php echo "$w_test1"; ?>" style="width:80px;" placeholder="650"/></p><br /><br />
            <p style="left:30px;"><input name="test2" type="checkbox"/> SAT</p><p style="left:130px;"><input name="date_test2" type="text" value="<?php echo "$date_test2"; ?>" style="width:80px;" /></p><p style="left:220px;"><input name="score_test2" type="text" value="<?php echo "$score_test2"; ?>" style="width:80px;" /></p><p style="left:387px;"><input name="v_test2" type="text" value="<?php echo "$v_test2"; ?>" style="width:80px;" /></p><p style="left:504px;"><input name="m_test2" type="text" value="<?php echo "$m_test2"; ?>" style="width:80px;" /></p><p style="left:622px;"><input name="w_test2" type="text" value="<?php echo "$w_test2"; ?>" style="width:80px;" /></p><br /><br />
            <p style="left:30px;"><input name="test3" type="checkbox"/> SAT</p><p style="left:130px;"><input name="date_test3" type="text" value="<?php echo "$date_test3"; ?>" style="width:80px;" /></p><p style="left:220px;"><input name="score_test3" type="text" value="<?php echo "$score_test3"; ?>" style="width:80px;" /></p><p style="left:387px;"><input name="v_test3" type="text" value="<?php echo "$v_test3"; ?>" style="width:80px;" /></p><p style="left:504px;"><input name="m_test3" type="text" value="<?php echo "$m_test3"; ?>" style="width:80px;" /></p><p style="left:622px;"><input name="w_test3" type="text" value="<?php echo "$w_test3"; ?>" style="width:80px;" /></p><br /><br />
            <p style="left:30px;"><input name="test4" type="text" value="<?php echo "$test4"; ?>" style="width:80px;"/></p><p style="left:130px;"><input name="date_test4" type="text" value="<?php echo "$date_test4"; ?>" style="width:80px;" /></p><p style="left:220px;"><input name="score_test4" type="text" value="<?php echo "$score_test4"; ?>" style="width:80px;" /></p><br /><br />
            <p style="left:30px;"><input name="test5" type="text" value="<?php echo "$test5"; ?>" style="width:80px;"/></p><p style="left:130px;"><input name="date_test5" type="text" value="<?php echo "$date_test5"; ?>" style="width:80px;" /></p><p style="left:220px;"><input name="score_test5" type="text" value="<?php echo "$score_test5"; ?>" style="width:80px;" /></p><br /><br />
            <p style="left:30px;"><input name="test6" type="text" value="<?php echo "$test6"; ?>" style="width:80px;"/></p><p style="left:130px;"><input name="date_test6" type="text" value="<?php echo "$date_test6"; ?>" style="width:80px;" /></p><p style="left:220px;"><input name="score_test6" type="text" value="<?php echo "$score_test6"; ?>" style="width:80px;" /></p><br /><br />
            <p style="left:30px;"><input name="test7" type="text" value="<?php echo "$test7"; ?>" style="width:80px;"/></p><p style="left:130px;"><input name="date_test7" type="text" value="<?php echo "$date_test7"; ?>" style="width:80px;" /></p><p style="left:220px;"><input name="score_test7" type="text" value="<?php echo "$score_test7"; ?>" style="width:80px;" /></p><br /><br />
            <input id="SaveAccount" type="submit" value="Save" style="position:absolute; left:300px;" />
          </div>
        </fieldset>
        <fieldset>
          <legend>Courses</legend>
          <div id="form-el">
            <h4 style="left:120px;">First Semester</h4><h4 style="left:490px;">Second Semester</h4><br /><br />
            <p><input name="c1f" type="text" value="<?php echo "$c1f"; ?>" style="width:160px;"/></p><p style="left:170px;"><input name="c2f" type="text" value="<?php echo "$c2f"; ?>" style="width:160px;" /></p><p style="left:380px;"><input name="c1s" type="text" value="<?php echo "$c1s"; ?>" style="width:160px;"/></p><p style="left:550px;"><input name="c2s" type="text" value="<?php echo "$c2s"; ?>" style="width:160px;" /></p><br /><br />
            <p><input name="c3f" type="text" value="<?php echo "$c3f"; ?>" style="width:160px;"/></p><p style="left:170px;"><input name="c4f" type="text" value="<?php echo "$c4f"; ?>" style="width:160px;" /></p><p style="left:380px;"><input name="c3s" type="text" value="<?php echo "$c3s"; ?>" style="width:160px;"/></p><p style="left:550px;"><input name="c4s" type="text" value="<?php echo "$c4s"; ?>" style="width:160px;" /></p><br /><br />
            <p><input name="c5f" type="text" value="<?php echo "$c5f"; ?>" style="width:160px;"/></p><p style="left:170px;"><input name="c6f" type="text" value="<?php echo "$c6f"; ?>" style="width:160px;" /></p><p style="left:380px;"><input name="c5s" type="text" value="<?php echo "$c5s"; ?>" style="width:160px;"/></p><p style="left:550px;"><input name="c6s" type="text" value="<?php echo "$c6s"; ?>" style="width:160px;" /></p><br /><br />
            <p><input name="c7f" type="text" value="<?php echo "$c7f"; ?>" style="width:160px;"/></p><p style="left:170px;"><input name="c8f" type="text" value="<?php echo "$c8f"; ?>" style="width:160px;" /></p><p style="left:380px;"><input name="c7s" type="text" value="<?php echo "$c7s"; ?>" style="width:160px;"/></p><p style="left:550px;"><input name="c8s" type="text" value="<?php echo "$c8s"; ?>" style="width:160px;" /></p><br /><br />
            <p><input name="c9f" type="text" value="<?php echo "$c9f"; ?>" style="width:160px;"/></p><p style="left:170px;"><input name="c10f" type="text" value="<?php echo "$c10f"; ?>" style="width:160px;" /></p><p style="left:380px;"><input name="c9s" type="text" value="<?php echo "$c9s"; ?>" style="width:160px;"/></p><p style="left:550px;"><input name="c10s" type="text" value="<?php echo "$c10s"; ?>" style="width:160px;" /></p><br /><br />
            <p><input name="c11f" type="text" value="<?php echo "$c11f"; ?>" style="width:160px;"/></p><p style="left:170px;"><input name="c12f" type="text" value="<?php echo "$c12f"; ?>" style="width:160px;" /></p><p style="left:380px;"><input name="c11s" type="text" value="<?php echo "$c11s"; ?>" style="width:160px;"/></p><p style="left:550px;"><input name="c12s" type="text" value="<?php echo "$c12s"; ?>" style="width:160px;" /></p><br /><br />
            <p><input name="c13f" type="text" value="<?php echo "$c13f"; ?>" style="width:160px;"/></p><p style="left:170px;"><input name="c14f" type="text" value="<?php echo "$c14f"; ?>" style="width:160px;" /></p><p style="left:380px;"><input name="c13s" type="text" value="<?php echo "$c13s"; ?>" style="width:160px;"/></p><p style="left:550px;"><input name="c14s" type="text" value="<?php echo "$c14s"; ?>" style="width:160px;" /></p><br /><br />
            <input id="SaveAccount" type="submit" value="Save" style="position:absolute; left:300px;" />
          </div>
        </fieldset>
        <fieldset>
          <legend>Parent 1</legend>
          <div id="form-el">
            <p>Name: <input name="ln_prnt1" type="text" value="<?php echo "$ln_prnt1"; ?>" style="width:80px;" placeholder="Chen"/> <input name="fn_prnt1" type="text" value="<?php echo "$fn_prnt1"; ?>" style="width:120px;" placeholder="Liang"/></p>
            <p style="left:300px;">Title:
              <select name="title_prnt1" style="width:60px;">
                <option value="<?php echo "$title_prnt1"; ?>"><?php echo "$title_prnt1"; ?></option>
                <option value="Mr.">Mr.</option>
                <option value="Ms.">Ms.</option>
              </select>
            </p>
            <p style="left:460px;"><input name="living_prnt1" type="checkbox"/> Living &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="deceased_prnt1" type="checkbox"/> Deceased&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="unknown_prnt1" type="checkbox"/> Unknown</p><br /><br />
            <p>Relation: <input name="relation_prnt1" type="text" value="<?php echo "$relation_prnt1"; ?>" style="width:80px;" placeholder="father"/></p>
            <p style="left:160px;">Birth Date: <input name="date_birth_prnt1" type="text" value="<?php echo "$date_birth_prnt1"; ?>" style="width:80px;" placeholder="dd/mm/yyyy"/></p>
            <p style="left:328px;">Birth Place: <input name="city_birth_prnt1" type="text" value="<?php echo "$city_birth_prnt1"; ?>" style="width:120px;" placeholder="Hangzhou"/> <input name="prov_birth_prnt1" type="text" value="<?php echo "$prov_birth_prnt1"; ?>" style="width:90px;" placeholder="Zhejiang"/> <input name="country_birth_prnt1" type="text" value="<?php echo "$country_birth_prnt1"; ?>" style="width:90px;" placeholder="China"/></p><br /><br />
            <p>Address: <input name="street_prnt1" type="text" value="<?php echo "$street_prnt1"; ?>" style="width:210px;" placeholder="225 Quankou Road"/> <input name="building_prnt1" type="text" value="<?php echo "$building_prnt1"; ?>" style="width:210px;" placeholder="Building 12, Apartment 302"/> <input name="city_prnt1" type="text" value="<?php echo "$city_prnt1"; ?>" style="width:220px;" placeholder="Wenling, Zhejiang 317500"/></p><br /><br />
            <p>Guardianship: 
            <select name="guardian_prnt1" style="width:60px;">
              <option value="<?php echo "$guardian_prnt1"; ?>"><?php echo "$guardian_prnt1"; ?></option>
              <option value="Yes">Yes</option>
              <option value="No">No</option>
            </select>
            </p>
            <p style="left:173px">Phone Number: <input name="cc_prnt1" type="text" value="<?php echo "$cc_prnt1"; ?>" style="width:30px;" placeholder="86"/> <input name="phone_prnt1" type="text" value="<?php echo "$phone_prnt1"; ?>" style="width:120px;" placeholder="18651751751"/></p>
            <p style="left:448px;">Email: <input name="email_prnt1" type="text" value="<?php echo "$email_prnt1"; ?>" style="width:220px;" placeholder="go2america@yahoo.com"/></p><br /><br />
            <p>High School: <input name="hs_prnt1" type="text" value="<?php echo "$hs_prnt1"; ?>" style="width:223px;" placeholder="Taizhou No.1 Senior High School"/></p>
            <p style="left:323px;">Address: <input name="hs_add_prnt1" type="text" value="<?php echo "$hs_add_prnt1"; ?>" style="width:330px;" placeholder="Hangzhou, Zhejiang, China"/></p><br /><br />
            <p>College: <input name="col_prnt1" type="text" value="<?php echo "$col_prnt1"; ?>" style="width:248px;" placeholder="Taizhou No.1 Senior High School"/></p>
            <p style="left:325px;">Degree: <input name="col_deg_prnt1" type="text" value="<?php echo "$col_deg_prnt1"; ?>" style="width:200px;" placeholder="Hangzhou, Zhejiang, China"/></p>
            <p style="left:596px;">Year: <input name="col_year_prnt1" type="text" value="<?php echo "$col_year_prnt1"; ?>" style="width:80px;" placeholder="1990"/></p><br /><br />
            <p>Graduate School: <input name="gr_prnt1" type="text" value="<?php echo "$gr_prnt1"; ?>" style="width:200px;" placeholder="Taizhou No.1 Senior High School"/></p>
            <p style="left:325px;">Degree: <input name="gr_deg_prnt1" type="text" value="<?php echo "$gr_deg_prnt1"; ?>" style="width:200px;" placeholder="Hangzhou, Zhejiang, China"/></p>
            <p style="left:596px;">Year: <input name="gr_year_prnt1" type="text" value="<?php echo "$gr_year_prnt1"; ?>" style="width:80px;" placeholder="1990"/></p><br /><br />
            <p>Employer: <input name="work_add_prnt1" type="text" value="<?php echo "$work_add_prnt1"; ?>" style="width:200px;" placeholder="Taizhou No.1 Senior High School"/></p>
            <p style="left:300px;">Position: <input name="work_position_prnt1" type="text" value="<?php echo "$work_position_prnt1"; ?>" style="width:125px;" placeholder="director"/></p>
            <p style="left:506px;">Phone: <input name="work_cc_prnt1" type="text" value="<?php echo "$work_cc_prnt1"; ?>" style="width:30px;" placeholder="86"/> <input name="work_phone_prnt1" type="text" value="<?php echo "$work_phone_prnt1"; ?>" style="width:120px;" placeholder="186651751751"/></p><br /><br />
            <p>Address: <input name="work_street_prnt1" type="text" value="<?php echo "$work_street_prnt1"; ?>" style="width:210px;" placeholder="225 Quankou Road"/> <input name="work_building_prnt1" type="text" value="<?php echo "$work_building_prnt1"; ?>" style="width:210px;" placeholder="Building 12, Apartment 302"/> <input name="work_city_prnt1" type="text" value="<?php echo "$work_city_prnt1"; ?>" style="width:220px;" placeholder="Wenling, Zhejiang 317500"/></p><br /><br />
            <input id="SaveAccount" type="submit" value="Save" style="position:absolute; left:300px;" />
          </div>
        </fieldset>
        <fieldset>
          <legend>Parent 2</legend>
          <div id="form-el">
            <p>Name: <input name="ln_prnt2" type="text" value="<?php echo "$ln_prnt2"; ?>" style="width:80px;" placeholder="Chen"/> <input name="fn_prnt2" type="text" value="<?php echo "$fn_prnt2"; ?>" style="width:120px;" placeholder="Liang"/></p>
            <p style="left:300px;">Title:
              <select name="title_prnt2" style="width:60px;">
                <option value="<?php echo "$title_prnt2"; ?>"><?php echo "$title_prnt2"; ?></option>
                <option value="Mr.">Mr.</option>
                <option value="Ms.">Ms.</option>
              </select>
            </p>
            <p style="left:460px;"><input name="living_prnt2" type="checkbox"/> Living &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="deceased_prnt2" type="checkbox"/> Deceased&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="unknown_prnt2" type="checkbox"/> Unknown</p><br /><br />
            <p>Relation: <input name="relation_prnt2" type="text" value="<?php echo "$relation_prnt2"; ?>" style="width:80px;" placeholder="mother"/></p>
            <p style="left:160px;">Birth Date: <input name="date_birth_prnt2" type="text" value="<?php echo "$date_birth_prnt2"; ?>" style="width:80px;" placeholder="dd/mm/yyyy"/></p>
            <p style="left:328px;">Birth Place: <input name="city_birth_prnt2" type="text" value="<?php echo "$city_birth_prnt2"; ?>" style="width:120px;" placeholder="Hangzhou"/> <input name="prov_birth_prnt2" type="text" value="<?php echo "$prov_birth_prnt2"; ?>" style="width:90px;" placeholder="Zhejiang"/> <input name="country_birth_prnt2" type="text" value="<?php echo "$country_birth_prnt2"; ?>" style="width:90px;" placeholder="China"/></p><br /><br />
            <p>Address: <input name="street_prnt2" type="text" value="<?php echo "$street_prnt2"; ?>" style="width:210px;" placeholder="225 Quankou Road"/> <input name="building_prnt2" type="text" value="<?php echo "$building_prnt2"; ?>" style="width:210px;" placeholder="Building 12, Apartment 302"/> <input name="city_prnt2" type="text" value="<?php echo "$city_prnt2"; ?>" style="width:220px;" placeholder="Wenling, Zhejiang 317500"/></p><br /><br />
            <p>Guardianship: 
            <select name="guardian_prnt2" style="width:60px;">
              <option value="<?php echo "$guardian_prnt2"; ?>"><?php echo "$guardian_prnt2"; ?></option>
              <option value="Yes">Yes</option>
              <option value="No">No</option>
            </select>
            </p>
            <p style="left:173px">Phone Number: <input name="cc_prnt2" type="text" value="<?php echo "$cc_prnt2"; ?>" style="width:30px;" placeholder="86"/> <input name="phone_prnt2" type="text" value="<?php echo "$phone_prnt2"; ?>" style="width:120px;" placeholder="18651751751"/></p>
            <p style="left:448px;">Email: <input name="email_prnt2" type="text" value="<?php echo "$email_prnt2"; ?>" style="width:220px;" placeholder="go2america@yahoo.com"/></p><br /><br />
            <p>High School: <input name="hs_prnt2" type="text" value="<?php echo "$hs_prnt2"; ?>" style="width:223px;" placeholder="Taizhou No.1 Senior High School"/></p>
            <p style="left:323px;">Address: <input name="hs_add_prnt2" type="text" value="<?php echo "$hs_add_prnt2"; ?>" style="width:330px;" placeholder="Hangzhou, Zhejiang, China"/></p><br /><br />
            <p>College: <input name="col_prnt2" type="text" value="<?php echo "$col_prnt2"; ?>" style="width:248px;" placeholder="Taizhou No.1 Senior High School"/></p>
            <p style="left:325px;">Degree: <input name="col_deg_prnt2" type="text" value="<?php echo "$col_deg_prnt2"; ?>" style="width:200px;" placeholder="Hangzhou, Zhejiang, China"/></p>
            <p style="left:596px;">Year: <input name="col_year_prnt2" type="text" value="<?php echo "$col_year_prnt2"; ?>" style="width:80px;" placeholder="1990"/></p><br /><br />
            <p>Graduate School: <input name="gr_prnt2" type="text" value="<?php echo "$gr_prnt2"; ?>" style="width:200px;" placeholder="Taizhou No.1 Senior High School"/></p>
            <p style="left:325px;">Degree: <input name="gr_deg_prnt2" type="text" value="<?php echo "$gr_deg_prnt2"; ?>" style="width:200px;" placeholder="Hangzhou, Zhejiang, China"/></p>
            <p style="left:596px;">Year: <input name="gr_year_prnt2" type="text" value="<?php echo "$gr_year_prnt2"; ?>" style="width:80px;" placeholder="1990"/></p><br /><br />
            <p>Employer: <input name="work_add_prnt2" type="text" value="<?php echo "$work_add_prnt2"; ?>" style="width:200px;" placeholder="Taizhou No.1 Senior High School"/></p>
            <p style="left:300px;">Position: <input name="work_position_prnt2" type="text" value="<?php echo "$work_position_prnt2"; ?>" style="width:125px;" placeholder="director"/></p>
            <p style="left:506px;">Phone: <input name="work_cc_prnt2" type="text" value="<?php echo "$work_cc_prnt2"; ?>" style="width:30px;" placeholder="86"/> <input name="work_phone_prnt2" type="text" value="<?php echo "$work_phone_prnt2"; ?>" style="width:120px;" placeholder="186651751751"/></p><br /><br />
            <p>Address: <input name="work_street_prnt2" type="text" value="<?php echo "$work_street_prnt2"; ?>" style="width:210px;" placeholder="225 Quankou Road"/> <input name="work_building_prnt2" type="text" value="<?php echo "$work_building_prnt2"; ?>" style="width:210px;" placeholder="Building 12, Apartment 302"/> <input name="work_city_prnt2" type="text" value="<?php echo "$work_city_prnt2"; ?>" style="width:220px;" placeholder="Wenling, Zhejiang 317500"/></p><br /><br />
            <input id="SaveAccount" type="submit" value="Save" style="position:absolute; left:300px;" />
          </div>
        </fieldset>
      </form>
      <div style="position:absolute; left:150px; top:600px;">
        <p>© 2012 </p>
      </div>
    </div>
  </div>
</body>
</html>
Member Avatar
cereal
Posting Virtuoso
1,710 posts since Aug 2007
Reputation Points: 461 [?]
Q&As Helped to Solve: 345 [?]
Skill Endorsements: 44 [?]
 
0
 

Did you tried to print_r($_POST); at very top of the file to check if everyting you need is retrieved?
Second: add or die(mysql_error()); at the end of the update query, line 351 and check what happens, bye.

Member Avatar
joshmac
Junior Poster
119 posts since Apr 2008
Reputation Points: 0 [?]
Q&As Helped to Solve: 5 [?]
Skill Endorsements: 0 [?]
 
0
 

Also, that is a lot of fields to list which makes your code quite long. You might want to look into some sort of mysql class that makes this easier and/or check out something like the CRUD method: http://net.tutsplus.com/tutorials/php/real-world-oop-with-php-and-mysql/

Member Avatar
jdgieschen
Newbie Poster
20 posts since Jan 2012
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

I'll check both those suggestions out. Just really can't figure this one out. Thanks.

Member Avatar
joshmac
Junior Poster
119 posts since Apr 2008
Reputation Points: 0 [?]
Q&As Helped to Solve: 5 [?]
Skill Endorsements: 0 [?]
 
0
 

@jdgieschen, I see you mysql SELECT statement, but where is your mysql UPDATE statement?

Member Avatar
joshmac
Junior Poster
119 posts since Apr 2008
Reputation Points: 0 [?]
Q&As Helped to Solve: 5 [?]
Skill Endorsements: 0 [?]
 
0
 

Nevermind, I see it. I think you should probably make another file, and start off with a smaller amount of code to figure out your issue and then start adding in more code. The bigger it is, the harder it is to troubleshoot.

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: