function display($m,$y,$d) { $db = mysql_connect("localhost", "miamisci_root", "m082440m"); mysql_select_db("miamisci_calendar",$db); $query="SELECT * FROM events WHERE month = '$m' AND year = '$y' AND day = '$d' ORDER BY day"; $result=mysql_query($query,$db); $myrow = mysql_fetch_array($result); if ($myrow) { echo "
"; $counter = 0; do { unset($emailtext); unset($titletext); unset($time); unset($timetext); unset($phonetext); $ID = $myrow["ID"]; $month = $myrow["month"]; $day = $myrow["day"]; $year = $myrow["year"]; $dayspan = $myrow["dayspan"]; $dateanchor = $myrow["date"]; $title = $myrow["title"]; $detail = nl2br($myrow["detail"]); $time = $myrow["time"]; $location = $myrow["location"]; $pic = $myrow["pic"]; $url = $myrow["url"]; $ename = $myrow["ename"]; $email = $myrow["email"]; $pname = $myrow["pname"]; $phone = $myrow["phone"]; if ($ename || $email) {$emailtext = "Email Contact: $ename $email";} if ($pname || $phone) {$phonetext = "Phone Contact: $pname $phone"; } } ?>
";} if ($url) {$titletext = "$title";} else {$titletext = $title;} if (!$dayspan) {$dayspan = $day;} $counter = $counter + 1; if ($counter == $numrows) { $hr = "";} else { $hr = "
";} echo "$titletext
$detail
Time: $time
Location: $location
$phonetext $emailtext $hr "; } while ($myrow = mysql_fetch_array($result)); echo "