");
// Connect to the database server
if (!($link=mysql_connect($hostName, $userName, $password))) {
DisplayErrMsg(sprintf("error connecting to host %s, by user %s",
$hostName, $userName));
exit();
}
// connect to the database
if (!mysql_select_db($databaseName, $link)) {
DisplayErrMsg(sprintf("error selecting database %s",
$databaseName));
exit();
}
// Create the temp table
if (!($result=mysql_query($sqld, $link))) {
DisplayErrMsg(sprintf("error executing SQL %s",
$sqld));
exit();
}
if (!($result=mysql_query($sqlc, $link))) {
DisplayErrMsg(sprintf("error:%d %s executing SQL %s",
mysql_errno($link), mysql_error($link), $sqlc));
exit();
}
// Select the data from the calendar for single day events
if (!($result=mysql_query($sqli . $sql1, $link))) {
DisplayErrMsg(sprintf("error executing SQL %s",
$sqli . $sql1));
exit();
}
// Select the data from the calendar for multi day events
if (!($result=mysql_query($sqli . $sql2, $link))) {
DisplayErrMsg(sprintf("error executing SQL %s",
$sqli . $sql2));
exit();
}
if (!($result=mysql_query($sqli . $sql3, $link))) {
DisplayErrMsg(sprintf("error executing SQL %s",
$sqli . $sql3));
exit();
}
// Select the data to display
if (!($result=mysql_query($sql0, $link))) {
DisplayErrMsg(sprintf("error executing SQL %s",
$sql0));
exit();
}
// Display the data
printf( "
|
Date
|
Event
|
Location
|
");
while (($row = mysql_fetch_object($result))){
printf("
| %s |
%s |
%s |
\n",
$row->EVENTDATES, stripslashes($row->EVENT), stripslashes($row->LOCATION)) ;
}
printf( "
" );
// free the results
// mysql_free_result($result);
if (!($result=mysql_query($sqld, $link))) {
DisplayErrMsg(sprintf("error executing SQL %s",
$sqld));
exit();
}
// disconnect from the database
mysql_close($link);
generateFooter();
?>
