Upcoming Events.
$dbhost = 'sunsetteam.db.8791093.hostedresource.com';
$dbuser = 'SunsRead';
$dbpass = 'W2vu3t1367';
$dbname = 'sunsetteam';
$con = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql: ' . mysql_error());
mysql_select_db($dbname);
$qry = "SELECT eventID, eventName, DATE_FORMAT(eventDate, '%m/%d/%y') eventDate, eventURL, eventTime, eventLocation, eventView, DATE_FORMAT(eventDateEnd, '%m/%d/%y') eventDateEnd FROM Coyote_Hole_Events WHERE (eventView='Yes') AND (eventDate >= CURDATE()) ORDER BY (eventDate)+0 ASC";
$re = mysql_query($qry, $con) or die (mysql_error());
$nr = mysql_num_rows($re);
$h = 0;
for ($h = 0; $h < $nr; $h++)
{
$eventID = mysql_result($re, $h, 'eventID');
$eventName = mysql_result($re, $h, 'eventName');
$eventURL = mysql_result($re, $h, 'eventURL');
$eventDate = mysql_result($re, $h, 'eventDate');
$eventTime = mysql_result($re, $h, 'eventTime');
$eventLocation = mysql_result($re, $h, 'eventLocation');
$eventView = mysql_result($re, $h, 'eventView');
$eventDateEnd = mysql_result($re, $h, 'eventDateEnd');
$urlLen = strlen($eventURL);
$endLen = strlen($eventDateEnd);
echo '
';
echo '
';
if ($urlLen > 0) {echo '' . $eventName . '';}
else {echo '' .$eventName . '';}
echo '
';
echo '
When: ' . $eventDate . ' ';
if ($eventDateEnd > 0) {echo ' - ' . $eventDateEnd . '';}
else {echo '';}
echo '
';
echo 'Where: ' . $eventLocation . '
';
echo 'Times: ' . $eventTime . '
';
echo '
';
}
?>