Selectare inregistrare aleatoare

[Double_Web]

Am o baza de date care are 5 coloane (intrebare, raspuns1, rasp2, rasp3, rasp4). Aceasta db are mai multe inregistrari. Cum fac sa selectez o inregistrare aleator ?

[Birkoff]

SELECT * FROM tabel
ORDER BY RAND()
LIMIT 1

[Double_Web]

[Birkoff]

[Double_Web]

[MihaiA]

$query = mysql_query("SELECT * FROM tabel ORDER BY RAND() LIMIT 1");
$query = mysql_fetch_assoc($query);

echo $query['intrebare'];
echo $query['rasp1'];
........

Le faci o asezare in tabel, etc.

[Double_Web]

[zeuscool]

<?php
$care = "select * from `zm_valori` order by rand() limit 1";
$sqlq = mysql_query($care);
$cate = mysql_num_rows($sqlq);
if ($cate == 1) {
$rand = mysql_fetch_assoc($sqlq);
print "Nume aleator: ".$rand['nume'];
}