PHP里的sql数据库有关问题

//查询
	$sql="SELECT * FROM `rv_duifu` where 1=1 $search order by id desc LIMIT $pageNum,$numPerPage";
	$db->query($sql);
	$list=$db->fetchAll();
	
	//echo $sql;
	//格式化输出数据
	foreach($list as $key=>$val){
		if($key%2==0){
			$list[$key][rowcss]="listOdd";
		}else{
			$list[$key][rowcss]="listEven";
		}
		$sql_lc="select * from `rv_licai` where id='".$list[$key][licaiid]."' limit 1";
		$db->query($sql_lc);
		$row_lc=$db->fetchRow();
		$list[$key][name_txt]=$row_lc['name'];
		$list[$key][qixian_txt]=$row_lc['qixian'];
		$list[$key][bdate_txt]=$row_lc['bdate'];
		$list[$key][ldate_txt]=$row_lc['ldate'];
		$list[$key][jine_txt]=$row_lc['jine'];
	}

	//模版
	$smt = new smarty();smarty_cfg($smt);
	$smt->assign('list',$list);
	$smt->assign('numPerPage',$_POST[numPerPage]); //显示条数
	$smt->assign('pageNum',$_POST[pageNum]); //当前页数
	$smt->assign('total',$total);
	$smt->assign('title',"列表");
	$smt->display('duifu_list.htm');