韩国网站高防服务器222.239.10.1mysql中union的使用方法例子

韩国网站高防服务器222.239.10.1mysql中union的使用方法例子

高防服务器租用 请联系：锐辉网络--小敏 ：.................................2853898501

获得图文回复

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