php ²éѯmysqlʱ£¬±íΪ¿Õʱ³ö´í

´úÂëÈçÏÂÇë¸÷λָÕýÒ»ÏÂÄÄÀï³ö´í£¬ÒªÔõô¸Ä£¬Ð»Ð» <?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");

?>