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 . '! •
<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: <input name="cur_public" type="checkbox" /> Public <input name="cur_private" type="checkbox"/> Private <input name="cur_boarding" type="checkbox"/> Boarding <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: <input name="fmr_public" type="checkbox"/> Public <input name="fmr_private" type="checkbox"/> Private <input name="fmr_boarding" type="checkbox"/> Boarding <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 <input name="deceased_prnt1" type="checkbox"/> Deceased <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 <input name="deceased_prnt2" type="checkbox"/> Deceased <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>
