include "styles.inc"; include "countdays.php"; include "dbconnect.php"; $query = "SELECT * FROM EVENTS WHERE NAME = 'Valentines day' ORDER by DATE"; $result = mysql_query($query); $event_set = mysql_fetch_array($result); $event_day = substr($event_set['DATE'],-2,2); $event_month = substr($event_set['DATE'],-4,2); if (strlen($event_set['DATE'])<=5){$event_yearfix = "200".substr($event_set['DATE'],-5,1);} else {$event_yearfix = "20".substr($event_set['DATE'],0,2);} $timeinseconds=mktime(0, 0, 0, $event_month, $event_day, $event_yearfix);//next event date $epochinseconds=mktime();//time now $timedifferenceinsecs=$timeinseconds-$epochinseconds; $timeleft=time_left($timedifferenceinsecs); $timetodate=substr($timeleft,0,17); $themeitem = split(",",$event_set['THEMESET']); ?>