Could not connect to server: " . mysql_error());
} else {
print "Connection succesfull
\n";
}
if (!mysql_select_db($db_name, $db_con)) {
die("
Could not select database $db_name: ". mysql_error());
} else {
print "Database $db_name selected
\n";
}
// some code -- QUERY
$query = <<The following query: $query
is invalid: " . mysql_error());
}
$num_results = mysql_num_rows($result);
print <<
The following query:
$query
returned $num_results tuples.
EOHeader;
$idx = 1;
while ($row = mysql_fetch_array($result)) {
$PI = $row['Principal_Investigator'];
$atitle = $row['Title'];
$money = $row['Amount_Awarded'];
print " $idx | $PI | $money | $atitle |
\n";
$idx++;
}
print <<
EOFooter;
// close connection
mysql_close($db_con);
?>