Order By Random正在创建错误


Order By Random is creating errors

以下是我想要使用的和我正在使用的:

$sql="SELECT * from channel ORDER BY rand() LIMIT 6 ";
$rs = $conn->
Execute($sql);
$channellist = $rs->
getrows();

但这会产生错误,整个网站都是空白的
在服务器错误日志中,这是错误:

[28-Jul-2013 09:53:37 America/Detroit] PHP Fatal error:  Call to a member function getrows() on a non-object in /home/hotspitt/public_html/cache/templates_c/%%C3^C37^C3724EE2%%head1.tpl.php on line 60

移除线路60($channellist = $rs->getrows();)使其工作。并将其更改为:

$sql="SELECT * from channel ORDER BY ID desc LIMIT 6 ";
$rs = $conn->
Execute($sql);
$channellist = $rs->
getrows();

让它发挥作用。所以我认为rand函数有问题。我不明白为什么rand()函数不起作用
请帮我解决这个问题。

select * from user_details order by rand() limit 10

正在工作,现在问题是您的表名或用于执行sql的库