if (($hour_end =='') && ($minute_end =='') && ($ampm_end =='')) { $end_time ='';}
else { $end_time= " - $hour_end:$minute_end $ampm_end"; }

if (($month_end =='') && ($day_end =='') && ($year_end =='')) { $end_date ='';}
else { $end_date= "- $month_end/$day_end/$year_end"; }

// Here is where we actually print out the events.  
echo "
<B>$event</B><br>
Location: $location <br />
Date: $month/$day/$year $end_date <br>
<br>"; 
$i++;
}

if (($hour_end =='') && ($minute_end =='') && ($ampm_end =='')) { $end_time ='';}
else { $end_time= " - $hour_end:$minute_end $ampm_end"; }

if (($day_end =='') && ($month_end =='') && ($year_end =='')) { $end_date ='';}
else { $end_date= "- $day_end/$month_end/$year_end"; }

// Here is where we actually print out the events.  Date: $month/$day/$year $end_date <br>
echo "
<B>$event</B><br>
Location: $location <br />
Date: $day/$month/$year $end_date <br>
<br>"; 
$i++;
}

$query="SELECT * FROM events WHERE
(year >= $current_year AND month > $current_month)
OR (year >= $current_year AND month = $current_month AND day >= $current_day)
OR (year_end >= $current_year AND month_end = $current_month AND day_end >= $current_day)
OR (year > $current_year)

OR (year_show >= $current_year AND month_show > $current_month)
OR (year_show >= $current_year AND month_show = $current_month AND day_show >= $current_day)
OR (year_show > $current_year)
ORDER BY year, month, day, ampm, hour LIMIT 0, $maxnum";

//replaces carriage returns with html line breaks
if ($html =="0") {
$description=preg_replace("/\n/","<br>", ($description));
}

// removes the first zero from the hour.  We need the zero at first, to keep the numbering in order.
//Of course the number ten needs the zero left in.
if ($hour !="10") {
$hour=preg_replace("/0/","", ($hour));
}

if ($hour_end !="10") {
$hour_end=preg_replace("/0/","", ($hour_end));
}

if (($hour_end =='') && ($minute_end =='') && ($ampm_end =='')) { $end_time ='';}
else { $end_time= " to $hour_end:$minute_end $ampm_end"; }

if (($month_end =='') && ($day_end =='') && ($year_end =='')) { $end_date ='';}
else { $end_date= "to $month_end/$day_end/$year_end"; }

// Here is where we actually print out the events.
$date_string = "$month/$day/$year";
$weekday = date('l', strtotime($date_string));
echo "
<tr>
<td>$weekday<br>$month/$day/$year<br><br>$hour:$minute $ampm $end_time</td>
<td>$event</td>
<td>$location<br>$phone</td>
<td>$description<br><a href='$link' target='_blank'>$link_name</a></td></tr>
";
// looks for the next event id and if it exists, prints it out.
$i++;
}
echo "</table></center>";

<?php
require_once('common.php');
checkUser();

// Your MySQL host
$dbhost='localhost';

//Your MySQL username
$dbuser='your_user_name';

//Your MySQL password
$dbpass='your_password';

//Your MySQL database name
$dbname='Your_database_name';

$todays_date=date('mdY');

$filename = "events$todays_date.csv";

$file = 'events';

$link = mysql_connect($dbhost,$dbuser,$dbpass) OR DIE ('Unable to connect to database! Please try again later.');
mysql_select_db($dbname) or die( "Unable to select database");

$result = mysql_query("SHOW COLUMNS FROM events");
$i = 0;
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$csv_output .= $row['Field']."; ";
$i++;
}
}
$csv_output .= "\n";

$values = mysql_query("SELECT * FROM events");
while ($rowr = mysql_fetch_row($values)) {
for ($j=0;$j<$i;$j++) {
$csv_output .= $rowr[$j]."; ";
}
$csv_output .= "\n";
}

header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header( "Content-disposition: filename=".$filename.".csv");
print $csv_output;
exit;
?>

[Sun May 09 00:31:25 2010] [error] [client 192.168.0.20] PHP Warning:  strtotime() [<a href='function.strtotime'>function.strtotime</a>]: It is not safe to rely on the system's timezone settings. You are *re
quired* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone ide
ntifier. We selected 'America/New_York' for 'EDT/-4.0/DST' instead in /archive2/www/events2/index.php on line 127