$year_d=date("Y",mktime(0,0,0,date("m")+1,1,date("Y")));
$month_d=date("m",mktime(0,0,0,date("m")+1,1,date("Y")));
?>
年月の日程表 |
$sql = "select date_format(n_date,'%c'),date_format(n_date,'%e'),time_format(n_time_start,'%H:%i'),time_format(n_time_end,'%H:%i'),n_title,n_contents from tbl_nittei where n_shop='".$shop_id."' and date_format(n_date,'%Y-%m')='".date("Y-m",mktime(0,0,0,date("m")+1,1,date("Y")))."' order by n_date";
$x = mysql_query($sql);
if(mysql_num_rows($x)>0){
while($cols = mysql_fetch_array($x)) {
?>
}
}else{
?>
}
?>
|