相关文章推荐,获取随机文章推荐,帮看看这个代码对不对
$sql = select * from `shops` where `subdomain` != '' order by rand() limit 100;
$rows = $db->getdata($sql);
foreach($rows as $row)
{
echo ''.$row['title'].'';
}
在文章页面需要获取随机文章做文章推荐,不知道怎么写,上面的对吗?
------解决方案--------------------
$sql = select * from (select * from `shops` where `subdomain` != '' order by rand() limit 100) t order by id desc;