<li data-role="collapsible"> <h1>中奖信息</h1> <ul> <?php $sql = "select * from t_activity where MemberID='$memberID'"; $res = $db->GetData($sql); while ($obj = mysqli_fetch_object($res)) { ?> <li><?php echo $obj->字段 ;?></li> <?php } ?> </ul> </li>
$res = $db->ExecSql($sql);
$num = mysqli_num_rows($res);问下mysql,怎么统计查询count(*)の行数,用上面的方法一直不成功!
<li data-role="collapsible"> <h1>中奖信息</h1> <ul> <?php $sql = "select * from t_activity where MemberID='$memberID'"; $res = $db->GetData($sql); while ($obj = mysqli_fetch_object($res)) { ?> <li><?php echo $obj->字段 ;?></li> <?php } ?> </ul> </li>
<li data-role="collapsible"> <h1>中奖信息</h1> <ul> <?php $sql = "select * from t_activity where MemberID='$memberID'"; $res = $db->GetData($sql); while ($obj = mysqli_fetch_object($res)) { ?> <li><?php echo $obj->字段 ;?></li> <?php } ?> </ul> </li>
またはこの样も可
<li data-role="collapsible"> <h1>中奖信息</h1> <ul> <?php $sql = "select * from t_activity where MemberID='$memberID'"; $res = $db->GetData($sql); while ($obj = mysqli_fetch_object($res)) { ?> <li><?php echo $obj->字段 ;?></li> <?php } ?> </ul> </li>
list($num) = mysqli_fetch_row($res);
$num = crrrent(mysqli_fetch_row($res));