1 AND del_flg<>1";
$sql = "SELECT * FROM $table_name";
$sql.= " WHERE".$where_str;
$sql.= " ORDER BY sort_num ASC,update_date DESC,id_code DESC;";
$rows = Database::num_rows($con,$table_name,$where_str);
$rs = Database::fetch_all($con, $sql);
//蜷�陦後�ｮ繝�繝ｼ繧ｿ繧呈ｼ邏�
$data = array();
for($m=0; $m<$rows; $m++) {
$data = $rs[$m];
for($n=0; $n
0) {
$today = time();
while(($now<$rows)&&($now>=$con_min)&&($now<$con_max)) {
//譌･莉俶ｯ碑ｼ�
$date_list = array();
$date_list = preg_split($date_pause,$date1[$now]);
$date = mktime(0,0,0,$date_list[1],$date_list[2],$date_list[0]);
if($date<=$today && $num<=$display) {
//逕ｻ蜒�
for ( $imgnum=1; $imgnum<=$image_num; $imgnum++ )
{
$image_file = ${"image".$imgnum}[$now];
$thumbnail = "";
$enlarged = "";
if(is_file(ROOT_DIR.UPLOAD_DIR.$image_file)) {
$thumbnail = LIB_DIR."resize_image.php?size=200&path=../".UPLOAD_DIR.$image_file;
$enlarged = LIB_DIR."resize_image.php?size=540&path=../".UPLOAD_DIR.$image_file;
$outdata[$out_num]['imgfile'.$imgnum.'_1'] = $enlarged;
$outdata[$out_num]['imgfile'.$imgnum.'_2'] = $thumbnail;
}
}
$outdata[$out_num]['id_code'] = $id_code[$now];
$outdata[$out_num]['year'] = $date_list[0];
preg_match ( "/[0-9][0-9]$/", $date_list[0] , $matches );
$outdata[$out_num]['year02'] = $matches[0];
$outdata[$out_num]['month'] = sprintf ( "%02d",$date_list[1] );
$outdata[$out_num]['day'] = sprintf ( "%02d",$date_list[2] );
$outdata[$out_num]['title'] = encode_sjis(encode_utf($title[$now]));
$outdata[$out_num]['comment'] = encode_sjis(encode_edit($comment[$now]));
$outdata[$out_num]['picswitch'] = $picswitch[$now];
$out_num++;
}
$now++;
}
$template->assign ( "outdata", $outdata );
$template->display ( "${table_name}_body.tpl" );
//繝�繝ｼ繧ｿ0莉ｶ縺ｮ蝣ｴ蜷�
} else{
print encode_sjis("迴ｾ蝨ｨ縲∵ュ蝣ｱ繧呈ｺ門ｙ荳ｭ縺ｧ縺吶�
");
}
↑ このページのトップに戻る
