文章目录[隐藏]
查询代码
$sql = "SELECT * FROM record where bumen like'%$bumen' and keduimokuai like '%$keduimokuai' and keti like '%$keti' and xingming like'%$xingming%'"; $result = mysql_query($sql); ?> <div style="margin:0 auto;width:100%;padding-top:10px"> <b class="tableTitle">表名:培训台账查询</b><br /> <b>返回</b> </div> <table width="100%" border="1"> <tr class="biaotou"> <td width="35">序号</td> <td width="60">部门</td> <td width="60">科队/模块</td> <em style="color:transparent">本@文来源[email protected]搞@^&代*@码网(</em><q>搞代gaodaima码</q> <td width="50">姓名</td> <td width="80">培训时间</td> <td width="150">培训课题</td> <td width="250">培训心得</td> </tr> <?php while($row = mysql_fetch_row($result)) { echo '<tr>'; foreach($row as $v) echo "<td>$v</td>"; echo '</tr>'; } ?> </table>
查询已经实现 怎么统计查询出来的数量并且输出?
回复讨论(解决方案)
$count=mysql_num_rows($result);