International Workshop on Air Quality Forecasting Research
Posters
");
$numcols = count($tableHeadings); //# of columns in report
$linked = $numcols-1; //url is last in listOfCols
$reportTable = "
\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 kind='posters' ORDER BY lastname";
// 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";
for ($i = 0; $i<$linked; $i++) {
$reportTable .= "| $row[$i] | \n";
}
$reportTable .= "$row[$linked] | \n";
$reportTable .= "
\n";
}
$reportTable .= "
\n";
echo "$reportTable\n";
?>
