$body_bgcolor ="#D7EBFF"; $body_text ="#333333"; $shop_id="dsoog"; //初期設定 $self_name="./campaign.php"; $dbname = "motoki"; $mysqluser = "motoki"; $mysqlpass = "mt021100"; $host = ""; $link = mysql_connect($host, $mysqluser, $mysqlpass); $con = mysql_select_db($dbname, $link); mysql_query('SET NAMES sjis', $link ); // 文字調整 ?>
$sql = "select
date_format(c_date_start,'%c'),
date_format(c_date_start,'%e'),
date_format(c_date_end,'%c'),
date_format(c_date_end,'%e'),
c_title,c_contents
from tbl_campaign
where (c_shop='".$shop_id."' or c_shop='all') and
date_format(c_date_end,'%Y-%m-%d')>='".date("Y-m-d")."'
order by c_date_start desc,c_id";
$x = mysql_query($sql);
if(mysql_num_rows($x)>0){
while($cols = mysql_fetch_array($x)) {
?>
} }else{ echo "予定はありません"; } ?> |