BLOUNGE｜".UE($crow[name])."〜".UE($trow[name])."\n"; ?> \n"; print " \n"; print "\n"; ?>
\n"; print " \n"; if ($ca_serial) { $cquery = "select * from category where (serial='$ca_serial')"; $cresult = mysql_query($cquery ,$db); $crow = mysql_fetch_array($cresult); print "

\"コレクション\"

\n"; } else { print "

\"コレクション\"

\n"; } print " \n"; print " \n"; print "
\n"; print "\n"; print "
\n"; $query = "select * from theme where (lev='1') and ((date_sta <= '$today') and ('$today' <= date_end)) order by num"; $result = mysql_query($query ,$db); $count = mysql_num_rows($result); if ($count > 0) { while ($row = mysql_fetch_array($result)) { print "\n"; if ($th_serial==$row[serial]) { //DB_connect(); $query2 = "select * from category where lev=1 order by num"; $result2 = mysql_query($query2 ,$db); $count2 = mysql_num_rows($result2); if ($count2 > 0) { while ($row2 = mysql_fetch_array($result2)) { $query3 = "select * from items where (lev='1') and (theme='$th_serial') and (category='$row2[serial]')"; $result3 = mysql_query($query3 ,$db); $row3 = mysql_fetch_array($result3); if (!empty($row3)) { print "\n"; } } } } } } print "
\n"; print " \n"; print "
\n"; print "
\n"; print " \n"; print " \n"; print "
\n"; print "
\n"; print " \n"; print " \n"; print " \n"; print "
\n"; print "
\n"; print " \n"; print " \n"; print " \n"; print " \n"; print "
\n"; ?>

 

$ca_name〜".UE($trow[name])."\n"; print "
\n"; $query1 = "select * from sub_category where (lev='1') and (serial='$sub_serial')"; $result1 = mysql_query($query1 ,$db); $count1 = mysql_num_rows($result1); $row1 = mysql_fetch_array($result1); print "

".UE($row1[com])."

\n"; print "
\n"; print "

 

\n"; print "
\n"; $query2 = "select * from items where (lev='1') and (theme='$th_serial')and(category='$ca_serial')and(sub_category='$sub_serial') order by num limit ".($page*$max).",$max"; $result2 = mysql_query($query2 ,$db); $count2 = mysql_num_rows($result2); if ($count2 > 0) { while ($row2 = mysql_fetch_array($result2)) { print "
\n"; $path = "../items_photo/$row2[photo1]"; if (($row2[photo1])&&(file_exists($path))) { //print "
\"".UE($row2[name])."\"
\n"; print "
\"".UE($row2[name])."\"
\n"; } else { print "
 
\n"; } //print "
".UE($row2[name])."
\n"; print "
".UE($row2[name])."
\n"; print "
\n"; } } print "
\n"; print " \n"; print " \n"; print " \n"; //page print "
\n"; print " \n"; print " \n"; print " \n"; print " \n"; print "
\n"; //カウント $query = "select count(*)as cnt from items where (lev='1') and (theme='$th_serial')and(category='$ca_serial')and(sub_category='$sub_serial')"; $result = mysql_query($query ,$db); $xrow = mysql_fetch_array($result); print " \n"; print "
\n"; print "
    \n"; if ($page > 0) { $prevpage = $page - 1; //print "
  • « prev
    • \n"; print "
  • « prev
    • \n"; } else { print "
  • « prev
    • \n"; } if ($page >= 10) { $bai = (floor($page / 10)) * 10; } $def=0+$bai ; $i=1+$bai; $i_cnt=1; for ($p=$def; $p<$xrow[cnt]; $p++) { if ($p == "$page") { print "
  • $i
    • \n"; } else { //print "
  • $i
    • \n"; print "
  • $i
    • \n"; } $i++; $i_cnt++; $cnt2 = $xrow[cnt] + $max; $chk = $i * $max; if (($chk >= $cnt2) || ($i_cnt > 10)) { break; } } if ($xrow[cnt] > (($page+1)*$max)) { $nextpage = $page + 1 ; print "
  • next »
    • \n"; } else { print "
  • next »
    • \n"; } print "
\n"; print "
\n"; ?>
Copyright ©  BLOUNGE
PageTop