Selecting Random Quotes from mySQL :(

[perlTest]

Hello there,

I've a mysql database which I want to select random quotes everytime. But I have no idea how to do that. My table is shown below:

quotes:
pid|text|link

I wanna select randomly each time. I've tried the following, but no luck.

$SQL = "SELECT text from quotes ORDER BY Rand()";

Please Help if you can. Thank You.

 

[sleipnir214]

What do you mean by "no luck". That type of query has worked for me before to select random records. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[perlTest]

What is the way you did? Following don't work:

$sql = qq[select TextAd from TextAds ORDER BY RAND()];

my $sth = $dbh->prepare("$sql"
$sth->execute or &head(&quot;Cannot execute statement!<br>&quot;.$sth->errstr);
while(@row = $sth->fetchrow) {
$random = $row[0];
}

print $random;