// ÀÛ¼ºÀÚ : ÃÖ»ó¹Î // ¼öÁ¤ÀÏ : 2002³â 3¿ù 11ÀÏ // ÆÄÀϸí : scheduleView.html // ÀÏÁ¤ º¸±â include ("../inc/header.html"); include ("../common/common.php"); include ("../common/dbConnect.php"); memberCheck1(); function printTable() { global $conn, $memberID, $id, $year, $day, $month; if($id == "" || $year == "" || $day == "" || $month == "") alert("ÃæºÐÇÑ º¯¼ö°¡ ³Ñ¾î¿ÀÁö ¾Ê¾Ò½À´Ï´Ù.", 2); $startDate = "$year-$month-$day"; $query = "select no, writer, id, DATE_FORMAT(startDate, '%Y-%m-%d') startDate, DATE_FORMAT(endDate, '%Y-%m-%d') endDate, subject, content, writeDate from schedule where id='$id' and startDate='$startDate' order by writeDate"; $result = $conn->runQuery($query); echo "
|
||
[$count] "; if($memberID == $rows[id]) echo ""; echo " $rows[subject] ($rows[startDate]~$rows[endDate]) | $rows[writer] ($rows[writeDate]) | |
$rows[content] |
||