/*************************************************************
ファイル名:bbs_list.php
--------------------------------------------------------------
内 容:ジャンルからレシピを検索
--------------------------------------------------------------
作成者:亘
作成日:2005.04.04
--------------------------------------------------------------
備 考:
**************************************************************/
require_once('../prepare.php');
require_once('./lib/config_bbs.php');
require_once('./lib/bbs_function.php');
function bbs_list($p){
$template =& loadTemplate( $p );
$this->db = cs4_open();
$this->user = u4user_open();
$where = "";
// 1ページの表示数
$p['page_count'] = 10;
switch($p['mode']){
case 'genre':
$where .= " rcp_dlt=0 and rcp_gnr='".$p['no']."' ";
break;
}
if(empty($p['page'])){
$p['page'] = 1;
$ret = cs4_select($this->db,"bsc_r_new",$where);
$i=0;
while($row = cs4_fetch_row($ret)){
$i++;
}
$p['count']=$i;
}
$list = "";
if($p['count'] == 0){
$list .= "レシピの登録がありません。\n
";
}else{
$p['start'] = ($p['page'] -1 ) * $p['page_count'];
$where .= " order by uniq_id desc limit ".$p['start'].",".$p['page_count'];
$ret = cs4_select($this->db,"bsc_r_new",$where);
while($row = cs4_fetch_row($ret)){
//- 会員登録確認
$user_prof = bsc_get_user_profile($this->user,$p['uid'],'0');
$regist_name = $user_prof['mem_nick_nm'];
$list .= "";
$list .= $row['rcp_nm']."\n
";
$list .= "";
$list .= "