NoMethodError (private method `rand' called for #<User::ActiveRecord_Relation:0x007fbab27d7ea8>):random_data.each do |rd|
...我知道在MySQL中有一种获取随机数据的方法,但我需要从数据库中提取随机数据400次
tbl_name WHERE id >= (SELECT FLOOR( MAX(id) * RAND()) FROM $tbl_name ) ORDER BY id LIMIT 1;$random_row = rand(1, $num_rows);SELECT * FROM $tbl_name WHERE
每次加载主页时,都会从MySQL数据库向页面显示随机图片/记录。这事已经结束了..。$filename = mysql_fetch_row(mysql_query("SELECT filename FROM pictures ORDER BY RAND() LIMIT 1"));这会将随机图片文件名回音到页面上。while ($record = mysql_fetch_array(mysql</
假设我有一个mySQL数据库:两列: ID和names,有100行。我想要做的是挑选出10个名字-没有重复-并以随机顺序显示它们。<?include('connection.php');
$sql = "SELECT * FROM names WHERE ID=$rand";
while ($row = <em