how to randomize return from mysql query...

[spewn]

i have a database with 4 entries, and i would like to display only 2 of them, randomly.

here's my code:

$dbh = DBI->connect("dbi:mysql:mydata","myuser","mypass");

$sth = $dbh->prepare("select oID from mytable");
$sth->execute;
$cnt = $sth->rows;
$dbh->disconnect();
use constant XOID => 0;
$y=0;

 while (@row = $sth8->fetchrow_array()) {

 $xid=$row[XOID];

print << "EOF";

here's where is show the results

EOF

$y++;

}

i'm looking online and trying to figure this out.

any ideas?

- g

 

[spewn]

i got it.

ORDER BY RAND() LIMIT 2

curiously, will won't return duplicate records, right?

thanks!

- g

 

[r937]

no, what happens is that it sorts all the rows in the table into random sequence, and then returns just 2 of them

so the only dupes that might occur would be actual dupe rows

r937.com | rudy.ca