php数据库获取内容如何排序?加了上下页后排序不能用如何解决?

<!doctype html>
<html>
<head>
<meta charset="gb2312">
<meta http-equiv="refresh" content="300">
<title></title>
<style type="text/css">
<!--
@import url(css/index.css);
@import url(css/common.css);
-->
</style>
<script type="text/javascript" src="js/jquery-2.1.4.min.js"></script>
<script type="text/javascript" src="js/common.js"></script>
<script type="text/javascript" src="js/float_window.js"></script>
</head>
<body>
<div class="all_pages">
    <header><iframe width="1800px" src="top.html" frameborder="0" scrolling="no"></iframe></header>
    <div class="middles">
        <div class="sub_middles1">
            <ul>
                <li id="slide_1" style="display:block;"><img src="images/index/slide_1.jpg"></li>
                <li id="slide_2" style="display:none;"><img src="images/index/slide_2.jpg"></li>
                <li id="slide_3" style="display:none;"><img src="images/index/slide_3.jpg"></li>
                <li id="slide_4" style="display:none;"><img src="images/index/slide_4.jpg"></li>
                <li id="slide_5" style="display:none;"><img src="images/index/slide_5.jpg"></li>
            </ul>
        </div>
        <div class="sub_middles2">
            <ul>
                <li οnmοuseοver="javascript:setFocus(1)"></li>
                <li οnmοuseοver="javascript:setFocus(2)"></li>
                <li οnmοuseοver="javascript:setFocus(3)"></li>
                <li οnmοuseοver="javascript:setFocus(4)"></li>
                <li οnmοuseοver="javascript:setFocus(5)"></li>
            </ul>
        </div>
        <div class="sub_middles3">
        <div id="left">
         <div id="left1" >
         <?php
            include_once '../../miaolaor0/fz/sjk.php'; /* 封装数据库 */
            $sql = "SELECT * FROM  `news_listing`order by news_Id desc";
            $query = mysql_query($sql);
            $pageIndex = 1;
            if(isset($_GET["page"]))
            {
                $pageIndex = $_GET["page"];//当前页
            }
            $pageSize =5;//每页显示行数
            $rowsCount = mysql_num_rows($query);//总行数
            $pageCount = intval($rowsCount / $pageSize);//页数
            if($rowsCount % $pageSize != 0)
            {
                $pageCount += 1;
            }
            
            $prePage = ($pageIndex==1)?1:($pageIndex-1);
            $nextPage = ($pageIndex<$pageCount)?($pageIndex+1):$pageCount;
            echo "<p>共".$rowsCount."行&nbsp;&nbsp;每页显示".$pageSize."条&nbsp;&nbsp;共".$pageCount."页&nbsp;&nbsp;
                <a href='index.php?page=".$prePage."'>上一页</a>&nbsp;<span class='cur_pg'>".$pageIndex."
                </span>&nbsp;<a href='index.php?page=".$nextPage."'>下一页</a></p>";
            
            $startRow = ($pageIndex-1)*$pageSize;//默认从第几行开始
            //分页查询指定页码的数据
            $sql = "select * from news_listing limit $startRow,$pageSize";
            //echo $sql;
            $query = mysql_query($sql);            
        ?>
        </div>
        <?php
       
            while ($u = mysql_fetch_array($query)) {

                ?>
                 <h6>
                 <a>
                <hr style="width:510px;">
                </a>
            </h6>
            <h2>
            <?php echo "<td><a href='news.php?AId=".$u[news_Id]."'>".$u[news_headline]."</a></td>";?>
                
            </h2>
            
            <h5>
              <?php echo"<td>".$u["news_time"]."</td>";?></h5>
                 
            
        <?php
                } //echo $sql;?>
        
        
        
        </div>
        <div id="dextron">
        <?php
            include_once '../../miaolaor0/fz/sjk.php'; /* 封装数据库 */
            $sql = "SELECT * FROM  `news_listing`order by news_Id desc";/*加了排序功能如果不加上下页功能的话可以用,加了不可以用如何解决?*/
            $query = mysql_query($sql);
            $pageIndex = 1;
            if(isset($_GET["page"]))
            {
                $pageIndex = $_GET["page"];//当前页
            }
            $pageSize =5;//每页显示行数
            $rowsCount = mysql_num_rows($query);//总行数
            $pageCount = intval($rowsCount / $pageSize);//页数
            if($rowsCount % $pageSize != 0)
            {
                $pageCount += 1;
            }
            
            $prePage = ($pageIndex==1)?1:($pageIndex-1);
            $nextPage = ($pageIndex<$pageCount)?($pageIndex+1):$pageCount;
            echo "<p>共".$rowsCount."行&nbsp;&nbsp;每页显示".$pageSize."条&nbsp;&nbsp;共".$pageCount."页&nbsp;&nbsp;
                <a href='index.php?page=".$prePage."'>上一页</a>&nbsp;<span class='cur_pg'>".$pageIndex."
                </span>&nbsp;<a href='index.php?page=".$nextPage."'>下一页</a></p>";
            
            $startRow = ($pageIndex-1)*$pageSize;//默认从第几行开始
            //分页查询指定页码的数据
            $sql = "select * from news_listing limit $startRow,$pageSize";
            //echo $sql;
            $query = mysql_query($sql);            
        ?>
        <?php
       
            while ($u = mysql_fetch_array($query)) {
                ?>
                 <h6>
                 <a>
                <hr style="width:510px;">
                </a>
            </h6>
            <h2>
            <?php echo "<td><a href='news.php?AId=".$u[news_Id]."'>".$u[news_headline]."</a></td>";?>
                
            </h2>
            
            <h5>
              <?php echo"<td>".$u["news_time"]."</td>";?></h5>
                 
        <?php
                } //echo $sql;?>
        
        
        </div>
            <ul>
                <li><img src="images/index/index_04.jpg" usemap="#sub_middlemenu_02"/>
                    <map name="sub_middlemenu_02">
                        <area coords="356,40,770,289" href="service_project.html" target="_parent"/>
                          <area coords="1052,88,1462,239" href="service_project.html" target="_parent"/>
                    </map>
                  </li>
                <li><img src="images/index/index_05.jpg"></li>
                <li><img src="images/index/index_06.jpg" usemap="#sub_middlemenu_03"/>
                    <map name="sub_middlemenu_03">
                        <area coords="343,80,821,223" href="service_project.html" target="_parent"/>
                    </map>
                </li>
                <li><img src="images/index/index_07.jpg"/></li>
                <li><img src="images/index/index_08.jpg" usemap="#sub_middlemenu_04"/>
                    <map name="sub_middlemenu_04">
                        <area coords="1049,82,1467,229" href="successful_case.html" target="_parent"/>
                    </map>
                  </li>
                <li><img src="images/index/index_09.jpg" usemap="#sub_middlemenu_05"/>
                    <map name="sub_middlemenu_05">
                        <area coords="348,17,601,291" href="#" target="_parent"/>
                        <area coords="629,17,882,291" href="#" target="_parent"/>
                        <area coords="914,17,1167,291" href="#" target="_parent"/>
                        <area coords="1198,17,1451,291" href="#" target="_parent"/>
                        <area coords="349,337,602,615" href="#" target="_parent"/>
                        <area coords="629,337,882,615" href="#" target="_parent"/>
                        <area coords="914,337,1167,615" href="#" target="_parent"/>
                        <area coords="1198,337,1451,615" href="#" target="_parent"/>
                    </map>
              </li>
            </ul>
        </div>
    </div>
    <footer><iframe width="1800px" height="197px" src="foot.html" frameborder="0" scrolling="no"></iframe></footer>
</div>
</body>
</html>

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值