query($q);
while ($us->next_record()) {
$user_id = $us -> f("user_id");
$userid = $userid."'".$user_id."'".",";
}
$len = strlen($userid);
$userid = substr($userid,0,$len-1);
$q = "select seq_no, user_id, user_name, title, contents, reg_date, proc_date, tflag from tbl_schedule where agentcode = '${MID}' AND user_id in ($userid) AND reg_date = '${reg_date}' ";
}else{
$q = "select seq_no, user_id, user_name, title, contents, reg_date, proc_date, tflag from tbl_schedule where agentcode = '${MID}' AND user_id = '${UID}' AND reg_date = '${reg_date}' ";
}
$q = $q." AND tflag='${tflag}'";
$q = $q." ORDER BY seq_no DESC ";
$sh -> query($q);
$total_record = $sh -> num_rows();
while ($sh->next_record()) {
$seq_no = $sh -> f("seq_no");
$user_id = $sh -> f("user_id");
$user_name = $sh -> f("user_name");
$title = longCut($sh -> f("title"), 30);
$contents = $sh -> f("contents");
$reg_date = $sh -> f("reg_date");
$tflag = $sh -> f("tflag");
?>
[개인][전체]
|
|
free();
if($total_record == 0){
?>
|
등록된 일정이 없습니다.
|
|
