".$row_rsAge['range']."\n"; } while ($row_rsAge = mysql_fetch_assoc($rsAge)); $dd=""; for($dob_dd=1;$dob_dd<32;$dob_dd++){ $dd .= ""; } $mm=""; for($dob_mm=1;$dob_mm<13;$dob_mm++){ $mm .= ""; } $yy=""; for($dob_yy=2009;$dob_yy>1929;$dob_yy--){ $yy .= ""; } $query_rsUniCountry = "SELECT * FROM `hsmp_uni_country` ORDER BY countryId"; $rsUniCountry = mysql_query($query_rsUniCountry, $ac) or die(mysql_error()); $row_rsUniCountry = mysql_fetch_assoc($rsUniCountry); $selUni = "\n"; do { $selUni .= "\n"; $query_rsUni = "SELECT * FROM `hsmp_uni` WHERE countryId = ".$row_rsUniCountry['countryId']." ORDER BY uniId"; $rsUni = mysql_query($query_rsUni, $ac) or die(mysql_error()); $row_rsUni = mysql_fetch_assoc($rsUni); do { $selUni .= "\n"; } while ($row_rsUni = mysql_fetch_assoc($rsUni)); } while ($row_rsUniCountry = mysql_fetch_assoc($rsUniCountry)); $query_rsQual = "SELECT * FROM `hsmp_qual` ORDER BY qualId"; $rsQual = mysql_query($query_rsQual, $ac) or die(mysql_error()); $row_rsQual = mysql_fetch_assoc($rsQual); $selQual = ""; do { $selQual .= "\n"; } while ($row_rsQual = mysql_fetch_assoc($rsQual)); $query_rsCountry = "SELECT * FROM `hsmp_country` ORDER BY name ASC"; $rsCountry = mysql_query($query_rsCountry, $ac) or die(mysql_error()); $row_rsCountry = mysql_fetch_assoc($rsCountry); $selCountry = ""; do { $selCountry .= "\n"; } while ($row_rsCountry = mysql_fetch_assoc($rsCountry)); $query_rsEarn = "SELECT * FROM `hsmp_earn_display` ORDER BY minvalue ASC"; $rsEarn = mysql_query($query_rsEarn, $ac) or die(mysql_error()); $row_rsEarn = mysql_fetch_assoc($rsEarn); do { $earn[$row_rsEarn['earnId']] = $row_rsEarn['minvalue']; } while ($row_rsEarn = mysql_fetch_assoc($rsEarn)); $selEarn = ""; foreach ($earn as $key => $value) { if ($value == min($earn)) { $selEarn .= "\n"; continue; } if ($value == max($earn)) { $selEarn .= "\n"; continue; } $selEarn .= "\n"; } $query_rsUkExp = "SELECT * FROM `hsmp_uk_exp` ORDER BY expId"; $rsUkExp = mysql_query($query_rsUkExp, $ac) or die(mysql_error()); $row_rsUkExp = mysql_fetch_assoc($rsUkExp); $selUkExp = ""; do { $selUkExp .= "\n"; } while ($row_rsUkExp = mysql_fetch_assoc($rsUkExp)); ?>