Aerosol Properties & Processes: 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 = 'CSL2' ORDER BY acronym"; // get result and close mysql connection $result = mysql_query($sql); 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"; ?>