$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; } ?>

Query failed : " . mysql_error() . "

"); if (mysql_num_rows($result)) { ?>

Database is Empty!!

"); mysql_free_result($result); //free resultset ?> "); if (mysql_num_rows($result) > 1) { ?> "); if (mysql_num_rows($result) > 1) { ?> "); if (mysql_num_rows($result) > 1) { ?> "); if (mysql_num_rows($result) > 1) { ?> "); if (mysql_num_rows($result) > 1) { ?>
Compound: name of the compound to find

Query failed : " . mysql_error() . "

Source: source material

Query failed : " . mysql_error() . "

Type: tissue/sample type
Position: position in the compound

Query failed : " . mysql_error() . "

Group: group of the structure

Query failed : " . mysql_error() . "

Multiplicity: the multiplicity of the proton resonance
Isotope: the type of nucleus

Query failed : " . mysql_error() . "

Shift Ref: type of chemical shift reference
Field: -> strength of the magnetic field in Tesla
pKa: -> pKa of the group
pH: -> pH of the sample
Shift: -> chemical shift in parts per million
Temperature: -> temperature of the sample in K
Sort By:
reset
= \"".$clean['field_s']."\" AND field <= \"".$clean['field_e']."\""; if (($clean['pka_s'])&&($clean['pka_e'])) $query .= " AND pka >= \"".$clean['pka_s']."\" AND pka <= \"".$clean['pka_e']."\""; if (($clean['ph_s'])&&($clean['ph_e'])) $query .= " AND ph >= \"".$clean['ph_s']."\" AND ph <= \"".$clean['ph_e']."\""; if (($clean['cs_s'])&&($clean['cs_e'])) $query .= " AND cs >= \"".$clean['cs_s']."\" AND cs <= \"".$clean['cs_e']."\""; if (($clean['temp_s'])&&($clean['temp_e'])) $query .= " AND temp >= \"".$clean['temp_s']."\" AND temp <= \"".$clean['temp_e']."\""; $query .= " ORDER BY ".$clean['sort_1']; if ($clean['sort_2']) $query .= ",".$clean['sort_2']; if ($clean['sort_3']) $query .= ",".$clean['sort_3']; $query .= " LIMIT ".$limit; $result = mysql_query($query, $mysql_link) or die(""); if (!mysql_num_rows($result)) echo ""; else { //--------------------------------------------------------------------------------------------- if (mysql_num_rows($result) == $limit) echo ""; ?> \n"; for ($i = 0; $i < 12; $i++) { if ((!$line[$i]) || ($line[$i] == "0.00")) $line[$i] = "n/a"; if (($i % 2) == 0) echo " \n"; else echo " \n"; } //end for echo "\n"; } //end while } //-------------------------------------------------------------------------------------------------- mysql_free_result($result); //free resultset ?>

Query failed : " . mysql_error() . "

No results fit those parameters
Please try another selection
Limited to ".$limit." Results
Please narrow down your selection
Compound Group H Mult. Isotope δ δRef pH pKa Field T(K) Type Reference
".$line[$i]."".$line[$i]."