<?


$vcnt = 8;


require( "../manage/common/define.php");

//DB接続クラスをインポート
require( LIB_PATH . "db.php");
$db = new db();



//表示頁
if( !$vp = $_REQUEST[p] ) $vp = 1;


$sql = "select
		SQL_CALC_FOUND_ROWS
		*,
		(select uri from t_file where id=t_dogs.img_1) img_1,
		(select uri from t_file where id=t_dogs.img_2) img_2
		from t_dogs
		where view_flg=1
		order by editdate desc
		
		limit ".(($vp-1)*$vcnt).", ".$vcnt."
		
		";



if( $rec = $db -> getFetchArray($sql, "utf8", "eucjp") ){
	
	while (list($key, $value) = @each($rec)) {
		switch ($value[gender]) {
			case 1:
				$rec[$key][gender] = "男の子";
				break;
			case 2:
				$rec[$key][gender] = "女の子";
				break;
			default:
				$rec[$key][gender] = "不明";
		}
		
		if( $value[img_1] ){
			$rec[$key][img] = "../common/dat/".$value[img_1];
		}elseif( $value[img_2] ){
			$rec[$key][img] = "../common/dat/".$value[img_2];
		}else{
			$rec[$key][img] = "../images\introduce/noimg.jpg";
		}
	}
	reset( $rec );
	
}




//総件数
$trec = $db->getone('SELECT FOUND_ROWS()');
$tcnt = $trec[0];

//頁数
$tpage = ceil( $tcnt / $vcnt );



//前ページ
$bp = $vp - 1;
if( $bp < 1 ) $bp = 1;

//次ページ
$np = $vp + 1;
if( $np > $tpage ) $np = $tpage;




require("./index.htm");

?>