\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 = 'CSL6' 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 .= "
* CSL has a Centrifugal Particle Mass Analyzer (CPMA), a device for selecting aerosol particles by their mass-to-charge ratio. The CPMA is available throughout the lab to help advance our science. Use the NOAA CSL CPMA Calendar to reserve the instrument.