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 connect"); $db = @mysql_select_db($db_name, $connection) or die ("Could not select database"); // Get list of lines: $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 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']; $option_block .= ""; } // Now get the list of stars: $sql = "SELECT Star_ID, Star_Name, HD FROM $table_name ORDER BY RA_hr, RA_min, RA_sec"; $result = @mysql_query($sql, $connection) or die("could not execute query"); while ($row=mysql_fetch_array($result)) { $Star_ID = $row['Star_ID']; $Star_Name = $row['Star_Name']; $HD = $row['HD']; $option_block2 .= ""; } // Now build the option block for stellar parameters $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; $option_block3 .=""; // Now get the list of species: $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']; $option_block4 .= ""; } $display_block = "
"; ?>
echo "$display_block"; ?>