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>

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.

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

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

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.