subscribe
 

RequestLink
MICRO
Advertiser and
Product
Information

Buyer's Guide
Buyers Guide

** New **

Greatest Hits of 2005
Greatest Hits of 2005

Featured Series
Featured Series


Web Sightings

Media Kit

Subscribe to MICRO

Comments? Suggestions? Send us your feedback.

 

MicroMagazine.com
11444 W.Olympic Blvd.
Los Angeles, CA 90064
310.445.3700

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
Buyers Guide | Subscribe to MICRO | Website Advertising Rates

Questions/comments about MICRO Magazine? E-mail us at feedback@micromagazine.com.

© 1997-2006 Canon Communications LLC
All rights reserved.