Pagina 1 din 1
Selectare inregistrare aleatoare
Scris: Vin Apr 20, 2012 3:48 pm
de 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 ?
Scris: Vin Apr 20, 2012 4:10 pm
de Birkoff
SELECT * FROM tabel
ORDER BY RAND()
LIMIT 1
Scris: Vin Apr 20, 2012 6:18 pm
de Double_Web
Scris: Vin Apr 20, 2012 6:28 pm
de Birkoff
Scris: Vin Apr 20, 2012 8:30 pm
de Double_Web
Scris: Vin Apr 20, 2012 8:41 pm
de 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.
Scris: Vin Apr 20, 2012 8:56 pm
de Double_Web
Scris: Vin Apr 20, 2012 9:24 pm
de 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'];
}