！！！！！高分求教smarty显示记录集，在线等。。。。。。。。。。。。。。。。。。。。。。。。

[boykent]

问题很简单我想在php中查寻一个记录集，然后用smarty显示？
//----------------------------------下面是php中代码----------------------
$query = "select * from tbl_owner where inservice=0 and issecondcheck is not null and isissueid is null and agentid = ".$aid." order by ownerid ";
$result = mysql_query( $query, $conn );
$rows_count = mysql_num_rows($result);
$smarty->assign("mysql_num_rows", $rows_count);

if($rows_count > 0){
$owner = mysql_fetch_array($result);
$smarty->assign("owner", $owner);
$smarty->assign("date",date("Y/m/d",$owner["isapplydata"]));
}


//----------------------------------下面是tpl中代码----------------------

{section name=item loop=$owner}
<tr>
<td width="14%">
<div align="center">{$owner[item].date|date_format:'%Y/%m/%d'}</div>
</td>
<td width="7%">
<div align="center">{$owner[item].ownerid}</div>
</td>
<tr>
{/section}

//----------------------------------------------
请问为什么查询纪录只有1条，然而却显示了124次，而且页面错乱，显示内容也不对？？？？？请帮忙解答一下，多谢了！！！

[foolbirdflyfirst]

if($rows_count > 0){
$owner = mysql_fetch_array($result);//你这样查询只是把指针指向的最后一条数据赋给了
//$owner,请用while循环取值

$smarty->assign("owner", $owner);
$smarty->assign("date",date("Y/m/d",$owner["isapplydata"]));
}

[boykent]

有道理，还有个问题顺便请教一下，解决就散分，谢谢了
第一个叶面
<input type="checkbox" name="check[0]" value="259" >
<input type="checkbox" name="check[1]" value="259" >
<input type="checkbox" name="check[2]" value="259" >
第二个叶面
for ( $i = 0; $i <= ($row - 1); $i++ ) {
if ( empty($check[$i]) == false) {
$password = MakePassphrase(8);
$query = "update tbl_owner set password = '".$password."',isissueid = ".date("U")." where ownerid = ".$check[$i].";";
MysqlQuery($query,$conn);
}
}

///////////////////
请问我如何在第二个叶面得到check得值，使得for这语句能执行成功？？？？？？？

[boykent]

定

[boykent]

我在定

[foolbirdflyfirst]

if ( empty($check[$i]) == false) ---> if(!empty($_POST['check'][$i]))

[boykent]

$_POST['check'][$i] 这个不行，取不到值

[foolbirdflyfirst]

<form action='2.php' method="post">
<input type="checkbox" name="check[0]" value="259" >
<input type="checkbox" name="check[1]" value="259" >
<input type="checkbox" name="check[2]" value="259" >
<input type="submit" value="submit">
</form>

2.php:
----------------
print_r($_POST['check']);


output: Array ( [0] => 259 [1] => 259 [2] => 259 )

[懒得去死]

摸板
<div id="div_result">{$result}</div>

$smarty->assign("result", $result);