调用会员在某个数据表发帖量的排行,没有发布信息的会员按照会员ID排序代码如下:select u.username,u.userid,(select count(*) from phome_ecms_photo where userid = u.userid) as myorder from phome_enewsmember
代码如下:[e:loop={select * from ( select id,clasid,titleurl,filename,title,newstime,titlepic from phome_ecms_book where newstime union select id,clasid,titleurl,filename,title,newstime,titlepic from ph
SQL 如何调用 所有软件下载的次数 下面就是调用方法了软件总下载数: gettotal("select sum(totaldown) as total from phome_ecms_download")次文章总浏览数:gettotal("select sum(onclick) as total from phome_ecms_n