| ||
|
= $current_year AND month > $current_month) OR (year >= $current_year AND month = $current_month AND day > $current_day) OR (year > $current_year) ORDER BY year, month, day LIMIT 3";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
//Get all the data and assign variables
$id=mysql_result($result,$i,"id");
$event=mysql_result($result,$i,"event");
$month=mysql_result($result,$i,"month");
$day=mysql_result($result,$i,"day");
$year=mysql_result($result,$i,"year");
$location=mysql_result($result,$i,"location");
$html=mysql_result($result,$i,"html");
// removes slashes
$description=stripslashes($description);
//replaces carriage returns with html line breaks
if ($html =="0") {
$description=preg_replace("/\n/"," ", ($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 ($endhour !="10") { $endhour=preg_replace("/0/","", ($endhour)); } // Here is where we actually print out the events. echo " $event: $month/$day/$year, $location "; echo ""; // looks for the next event id and if it exists, prints it out. $i++; } // If there are no scheduled events, print the no events message if (!mysql_num_rows($result)) { 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"); $query2="SELECT * FROM no_events WHERE id=1"; $result2=mysql_query($query2); $num2=mysql_numrows($result2); mysql_close(); $k=0; while ($k < $num2) { $description2=mysql_result($result2,$k,"description"); $description2=stripslashes($description2); $description2=preg_replace("/\n/"," ", ($description2)); echo "$description2"; $k++; } } ?> |
Join us in our mission to strengthen the arts community.
The mission of Arts Business Institute (ABI) is to strengthen the careers of artists across the United States and Canada. There are a number of ways that you can help support the important work of the ABI. To make a monetary donation by credit card or check, follow the link "click here to donate now" or complete the form below and one of our Gift Officers will contact you.
For more information please contact us at info@artsbusinessinstitute.org