 |
 |
 |
 |
|
** New **
Comments? Suggestions? Send us your feedback.
MicroMagazine.com |
 
MICRO Online Calendar='".$StartDate."' "; $sql .= " AND enddate <='".$EndDate."' "; $sql .= " AND eventsource ='4' "; $sql .= " order by startdate, enddate, eventname"; //echo $sql; $count = 1; $result = mysql_query($sql, $connection) or die(mysql_error()); if ($result === false) die("failed! ". $sql .mysql_error()); //loop through results while($row = mysql_fetch_array($result)) { //format event date $split = explode("-",$row['startdate']); $sYear = $split[0]; $sMonth = $split[1]; $sDay = $split[2]; $split = explode("-",$row['enddate']); $eYear = $split[0]; $eMonth = $split[1]; $eDay = $split[2]; $returndate = date ("F j", mktime(0,0,0,$sMonth,$sDay,$sYear)); if($sMonth == $eMonth && $sDay < $eDay){ $returndate .= "-".date ("j", mktime(0,0,0,$eMonth,$eDay,$eYear)); } elseif ($sMonth != $eMonth){ $returndate .= "-".date ("F j", mktime(0,0,0,$eMonth,$eDay,$eYear)); } //set year header; if($count == 1){ echo ''.$sYear .''; $currentYear = $sYear;} if ($currentYear <> $sYear){ echo ''.$sYear .' '; $currentYear = $sYear; } echo "".$returndate." "; echo $row['eventname']." "; if($row['eventvenue']<> ''){ if($row['eventvenue'] <> 'TBA'){ echo $row['eventvenue']."; ";} echo $row['eventcity']; if ($row['printable_name'] <> '' and $row['printable_name'] <> 'United States') { echo ", ".$row['printable_name']; } elseif($row['eventstate'] <> ''){ echo ", ".$row['eventstate'];} echo " "; } echo "Info: "; if ($row['eventwebsite'] <> ''){ echo "". ereg_replace("http://www.", "www.", $row['eventwebsite']).""; } echo " "; $count = $count + 1; } ?>
MicroHome |
Search | Current Issue | MicroArchives Questions/comments about MICRO Magazine? E-mail us at feedback@micromagazine.com. © 1997-2006 Canon
Communications LLC |
