mysql中union的使用方法例子

来源：互联网发布：网络文凭有用吗编辑：程序博客网时间：2024/06/18 05:37
/** * 获得图文回复*/   function getData($start, $limit)   {       $sql = "select count(*) from xx5_weixin.reply_msg";   $sql = "select count(*) from (         SELECT * FROM xx5_weixin.reply_pic_0         union all         SELECT * FROM xx5_weixin.reply_pic_1         union all         SELECT * FROM xx5_weixin.reply_pic_2         union all         SELECT * FROM xx5_weixin.reply_pic_3         union all         SELECT * FROM xx5_weixin.reply_pic_4         union all         SELECT * FROM xx5_weixin.reply_pic_5         union all         SELECT * FROM xx5_weixin.reply_pic_6         union all         SELECT * FROM xx5_weixin.reply_pic_7         union all         SELECT * FROM xx5_weixin.reply_pic_8         union all         SELECT * FROM xx5_weixin.reply_pic_9         union all         SELECT * FROM xx5_weixin.reply_pic_a         union all         SELECT * FROM xx5_weixin.reply_pic_b         union all         SELECT * FROM xx5_weixin.reply_pic_c         union all         SELECT * FROM xx5_weixin.reply_pic_d         union all         SELECT * FROM xx5_weixin.reply_pic_e         union all         SELECT * FROM xx5_weixin.reply_pic_f         ) as t";          $result=db_query($sql,$this->link,__FILE__,__LINE__);       list($total_row_count)=mysql_fetch_row($result);       $sql = "select * from (            SELECT * FROM xx5_weixin.reply_pic_0            union all            SELECT * FROM xx5_weixin.reply_pic_1            union all            SELECT * FROM xx5_weixin.reply_pic_2            union all            SELECT * FROM xx5_weixin.reply_pic_3            union all            SELECT * FROM xx5_weixin.reply_pic_4            union all            SELECT * FROM xx5_weixin.reply_pic_5            union all            SELECT * FROM xx5_weixin.reply_pic_6            union all            SELECT * FROM xx5_weixin.reply_pic_7            union all            SELECT * FROM xx5_weixin.reply_pic_8            union all            SELECT * FROM xx5_weixin.reply_pic_9            union all            SELECT * FROM xx5_weixin.reply_pic_a            union all            SELECT * FROM xx5_weixin.reply_pic_b            union all            SELECT * FROM xx5_weixin.reply_pic_c            union all            SELECT * FROM xx5_weixin.reply_pic_d            union all            SELECT * FROM xx5_weixin.reply_pic_e            union all            SELECT * FROM xx5_weixin.reply_pic_f         ) as t order by config_id asc,msg_id desc limit $start, $limit";       $result=db_query($sql,$this->link,__FILE__,__LINE__);       $rows=array();       while($row=mysql_fetch_assoc($result))       {           $rows[]=$row;       }       return array(           'rows'=>$rows,           'total_row_count'=>$total_row_count       );   }
0 0