$page = "Search"; $style = "select { width: 130px; }"; require("../header.php"); $limit = 100; // Clean the variables $clean = array ( ); $clean['name'] = mysql_real_escape_string($_POST['name']); $clean['pos'] = mysql_real_escape_string($_POST['pos']); $clean['grp'] = mysql_real_escape_string($_POST['grp']); $clean['multiplicity'] = mysql_real_escape_string($_POST['multiplicity']); $clean['isotope'] = mysql_real_escape_string($_POST['isotope']); $clean['cs_s'] = mysql_real_escape_string($_POST['cs_s']); $clean['cs_e'] = mysql_real_escape_string($_POST['cs_e']); $clean['csr'] = mysql_real_escape_string($_POST['csr']); $clean['ph_s'] = mysql_real_escape_string($_POST['ph_s']); $clean['ph_e'] = mysql_real_escape_string($_POST['ph_e']); $clean['pka_s'] = mysql_real_escape_string($_POST['pka_s']); $clean['pka_e'] = mysql_real_escape_string($_POST['pka_e']); $clean['field_s'] = mysql_real_escape_string($_POST['field_s']); $clean['field_e'] = mysql_real_escape_string($_POST['field_e']); $clean['temp_s'] = mysql_real_escape_string($_POST['temp_s']); $clean['temp_e'] = mysql_real_escape_string($_POST['temp_e']); $clean['type'] = mysql_real_escape_string($_POST['type']); $clean['ref'] = mysql_real_escape_string($_POST['ref']); $clean['sort_1'] = mysql_real_escape_string($_POST['sort_1']); $clean['sort_2'] = mysql_real_escape_string($_POST['sort_2']); $clean['sort_3'] = mysql_real_escape_string($_POST['sort_3']); /* ------ERROR CHECKING------ */ //if user hasn't typed in a number, set it to zero if (!is_numeric($clean['field_s'])) $clean['field_s'] = 0; if (!is_numeric($clean['field_e'])) $clean['field_e'] = 0; if (!is_numeric($clean['pka_s'])) $clean['pka_s'] = 0; if (!is_numeric($clean['pka_e'])) $clean['pka_e'] = 0; if (!is_numeric($clean['ph_s'])) $clean['ph_s'] = 0; if (!is_numeric($clean['ph_e'])) $clean['ph_e'] = 0; if (!is_numeric($clean['cs_s'])) $clean['cs_s'] = 0; if (!is_numeric($clean['cs_e'])) $clean['cs_e'] = 0; if (!is_numeric($clean['temp_s'])) $clean['temp_s'] = 0; if (!is_numeric($clean['temp_e'])) $clean['temp_e'] = 0; //if start is bigger than end swap them if ($clean['field_s'] > $clean['field_e']) { $temp = $clean['field_e']; $clean['field_e'] = $clean['field_s']; $clean['field_s'] = $temp; } if ($clean['pka_s'] > $clean['pka_e']) { $temp = $clean['pka_e']; $clean['pka_e'] = $clean['pka_s']; $clean['pka_s'] = $temp; } if ($clean['ph_s'] > $clean['ph_e']) { $temp = $clean['ph_e']; $clean['ph_e'] = $clean['ph_s']; $clean['ph_s'] = $temp; } if ($clean['cs_s'] > $clean['cs_e']) { $temp = $clean['cs_e']; $clean['cs_e'] = $clean['cs_s']; $clean['cs_s'] = $temp; } if ($clean['temp_s'] > $clean['temp_e']) { $temp = $clean['temp_e']; $clean['temp_e'] = $clean['temp_s']; $clean['temp_s'] = $temp; } ?>
require("../footer.php"); ?>