請教rand() 跟排序的問題 select * from TABLE order by rand(),addtime; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 不过这样意义不大。addtime不大可能有重复的吧 select * from (select * from TABLE order by addtime 这里先用addtime选出几条最新的) order by rand(); $sql = 'SELECT * FROM ployphoto INNER JOIN ploytype ';$sql.= "ON ployphoto.ptsn = ploytype.ptsn AND ployphoto.ppstatuse = 'o' ";$sql.= "AND ploytype.ptstatuse = 'o' AND ployphoto.ppstart = 'y' ";$sql.= "AND ploytype.ptstart = 'y' AND ployphoto.pplook = 'no' AND ployphoto.pisn > 0 ";$sql.= "AND ploytype.ptoffice = 'y' ";$sql.= "INNER JOIN ployimg ON ployphoto.ppsn = ployimg.ppsn ";$sql.= "AND ployphoto.pisn = ployimg.pisn ";$sql.= "ORDER BY rand() limit 0,4";我想從資料先拿出最新的幾個,然後再在最新的幾個隨機 用addtime做where筛选,然后rand排序 求教变量的传递 php-cli php-cgi 和apache 集成的区别是什么? PHP如何获得当前网址并且进行修改? PHP 中file函数效率问题?求助 PHP作为16进制修改器,有些难办问题 php压缩文件夹为zip的函数是什么? 传递中文问题 什么情况下form表单的onsubmit函数不起作用?是浏览器设置吗? 成功地在linux/unix下安装apache+php+oracle的人请进! mysql命令行中文乱码 大家帮我看一下,这个求父类的SQL语句该怎么写? editplus中菜单上"文档自动换行"怎么能设置为默认选中啊?
addtime不大可能有重复的吧
$sql = 'SELECT * FROM ployphoto INNER JOIN ploytype ';
$sql.= "ON ployphoto.ptsn = ploytype.ptsn AND ployphoto.ppstatuse = 'o' ";
$sql.= "AND ploytype.ptstatuse = 'o' AND ployphoto.ppstart = 'y' ";
$sql.= "AND ploytype.ptstart = 'y' AND ployphoto.pplook = 'no' AND ployphoto.pisn > 0 ";
$sql.= "AND ploytype.ptoffice = 'y' ";
$sql.= "INNER JOIN ployimg ON ployphoto.ppsn = ployimg.ppsn ";
$sql.= "AND ployphoto.pisn = ployimg.pisn ";
$sql.= "ORDER BY rand() limit 0,4";我想從資料先拿出最新的幾個,然後再在最新的幾個隨機