$dow = intval(strftime("%u")); if ($dow == 1) // monday { $monday = strtotime("today"); } else { $monday = strtotime("last monday"); } $startdate = strftime("%Y-%m-%d %H:%M", $monday); $sunday = strtotime("+6 days", $monday); $enddate = strftime("%Y-%m-%d %H:%M", $sunday); $sql = "select *, DATE_FORMAT(received, '%w'),price, title, venue as day_of_week from weekcalendar order by day_of_week"; $res = mysql_query($sql) or die( mysql_error() ); while ($row = mysql_fetch_assoc($res)) { $date = strftime("%m/%d", $row["received"]); $d = intval(strftime("%u", $row["received"])); $currentday = $row["received"]; print strftime("%A", $row["receivedepoch"]) . "
"; print "• {$date} Event: {$row[title]}ent_type]} price: {$row[price]} Venue: {$row[venue]}
\n"; } print "

"; print <<