請教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排序 addJavaScript()问题 向大家请教一个问题.....用PHP或HTML有或CSS来告诉我怎么弄都可以 关于页面跳转(链接超时的问题) 怎样向函数的一个参数提交两个值 php的session详细设置.(顶者散分) 急~关于在mysql中执行sql语句的问题~ 新手入门之一问(在线等。。。。) 如何遍例session 我应该怎么检查PHP页面是否在发送头信息之前有没有输出? 用post传递数据给php文件,PHP 总undefined 大家帮我看一下,这个求父类的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";我想從資料先拿出最新的幾個,然後再在最新的幾個隨機