U.S. FlagAn official website of the United States government
dot gov icon
Official websites use .gov

A .gov website belongs to an official government organization in the United States.

icon https icon
Secure .gov websites use HTTPS

A lock () or https:// means you've safely connected to the .gov website. Share sensitive information only on official, secure websites.

Atmospheric Remote Sensing: Instruments

Operational Instruments

\n\n"; for($i=0; $i<$numcols; $i++) { $reportTable .= "$tableHeadings[$i]\n"; } $reportTable .= "\n"; // connect to mysql $link = mysql_connect($mysqlServAddr, $mysqlUser, $mysqlPass) or die("Could not connect to server. MYSQL Error: " . mysql_error()); $db = mysql_select_db($mysqlDB, $link) or die("Could not connect to database. MYSQL Error: " . mysql_error()); $sql = "SELECT $listOfCols FROM $mysqlTable WHERE status = 'operational' AND grp = 'CSL3' ORDER BY acronym"; $sqlN = "SELECT $listOfCols FROM $mysqlTable WHERE status = 'nonoperational' AND grp = 'CSL3' ORDER BY acronym"; $sqlD = "SELECT $listOfCols FROM $mysqlTable WHERE status = 'decommissioned' AND grp = 'CSL3' ORDER BY acronym"; // get result and close mysql connection $result = mysql_query($sql); $resultN = mysql_query($sqlN); $resultD = mysql_query($sqlD); if (!$result) $phpErr = "Problem with query
MYSQL Error: " . mysql_error(); mysql_close($link); // handle output from query and build html response while ($row = mysql_fetch_row($result)) { $reportTable .= "\n"; if (!$row[$numcols]) { $reportTable .= "$row[0]\n"; } else { $reportTable .= "$row[0]\n"; } for ($i = 1; $i<$numcols; $i++) { $reportTable .= "$row[$i]\n"; } $reportTable .= "\n"; } $reportTable .= "\n"; echo "$reportTable\n"; ?>

Non-Operational Instruments

\n\n"; for($i=0; $i<$numcols; $i++) { $reportTableN .= "$tableHeadings[$i]\n"; } $reportTableN .= "\n"; // handle output from query and build html response while ($row = mysql_fetch_row($resultN)) { $reportTableN .= "\n"; if (!$row[$numcols]) { $reportTableN .= "$row[0]\n"; } else { $reportTableN .= "$row[0]\n"; } for ($i = 1; $i<$numcols; $i++) { $reportTableN .= "$row[$i]\n"; } $reportTableN .= "\n"; } $reportTableN .= "\n"; echo "$reportTableN\n"; ?>

Decommissioned Instruments

\n\n"; for($i=0; $i<$numcols; $i++) { $reportTableD .= "$tableHeadings[$i]\n"; } $reportTableD .= "\n"; // handle output from query and build html response while ($row = mysql_fetch_row($resultD)) { $reportTableD .= "\n"; if (!$row[$numcols]) { $reportTableD .= "$row[0]\n"; } else { $reportTableD .= "$row[0]\n"; } for ($i = 1; $i<$numcols; $i++) { $reportTableD .= "$row[$i]\n"; } $reportTableD .= "\n"; } $reportTableD .= "\n"; echo "$reportTableD\n"; ?>