php中查询记录为空是出错，怎办呢

Question

代码如下：请高手指点一下，怎么改才好
<?php
header("Content-type: text/vnd.wap.wml;charset=gb2312 \n");

echo("<?xml version=\"1.0\" encoding=\"gb2312\"?>\n");
echo("<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.1//EN\" \"http://www.wapforum.org/DTD/wml_1.1.xml\">\n");
echo "<wml>\n";

$page=isset($_GET['page'])?intval($_GET['page']):1;
$num=3;

$conn = mysql_connect('localhost','bb','fe');
if (!$conn) {
die('Could not connect:'.mysql_error());
}
mysql_select_db('sqlb');

$total=mysql_num_rows(mysql_query("SELECT id FROM oing"));

$pagenum=ceil($total/$num);

If($page>$pagenum || $page == 0){
Echo 'Error : Can Not Found The page.';
Exit;
}

$offset=($page-1)*$num;
mysql_query("SET NAMES GB2312");
$result=mysql_query("SELECT id,rname,sage FROM oing limit $offset,$num");

?>
<card id="no1" title="Card1">
<p>
大家的记录：
<br/>
<?php
While($it=mysql_fetch_array($result)){

//Echo $it['id']." ".$it['sage']."<br />";
$show= $it['rname']."：<br/><a href='wap/jlx.php?doid=".$it['id']."'> ".$it['sage']."</a>";
echo $show."<br/> <br/>";
}
?>

</p>
</card>
<?php

echo "</wml>\n";
mysql_free_result($result);
mysql_close($conn);

?>

Answer 1

你把这句分开写，先判断是不是为空。
$total=mysql_num_rows(mysql_query("SELECT id FROM oing"));
改成这样：
$result=mysql_query("SELECT id FROM oing");
if($result){
$total=mysql_num_rows($result);
}
else{
.....
}