session_start(); session_register('valid'); include('../db_select.php'); $db_name = "DIB"; $table_name = "star"; $connection = @mysql_connect("localhost","dib","herbig4430") or die("unable to establish a connection"); $db = @mysql_select_db($db_name, $connection) or die("unable to select database"); $sql = "SELECT Line_ID, Name, Vibronic_Band_Name, Adopted_Wavelength, Assignment FROM line as L INNER JOIN species as S ON L.Species_ID = S.Species_ID LEFT OUTER JOIN vibronic_band as V ON L.Vibronic_Band_ID = V.Vibronic_Band_ID WHERE L.Observed = 1 ORDER BY Adopted_Wavelength"; $result = @mysql_query($sql, $connection) or die("could not properly execute query"); while ($row=mysql_fetch_array($result)) { $Line_ID = $row['Line_ID']; $Adopted_Wavelength = $row['Adopted_Wavelength']; $Name = $row['Name']; $Vibronic_Band_Name = $row['Vibronic_Band_Name']; $Assignment = $row['Assignment']; $line_option_block .= ""; } $star_option_block = ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $star_option_block .= ""; $sql = "SELECT Species_ID, Name FROM species WHERE Species_ID!=1 ORDER BY Name"; $result = @mysql_query($sql, $connection) or die("could not execute query"); while ($row=mysql_fetch_array($result)) { $Species_ID = $row['Species_ID']; $Name = $row['Name']; $col_option_block .= ""; } ////////////////////////////////////////////////////////////////////// $display_block = "
"; ?>
echo "$display_block"; ?>