php-db | 2002122

[PHP-DB] random select From: Bruce Levick (bruce <email protected>)
Date: 12/17/02

Bruce Levick - VivamotionI was curious as to what is the best way to select
a random row from a table in my database.

I have currently five rows and will be expanding on that as well. I have
tried this code.

########################################################################
//retrieve random row
<?php
 $rndm = mysql_query("SELECT * FROM Illustrations ORDER BY RAND() LIMIT 1");
 if (!$rndm) {
      echo("<P>Error performing query: " .
           mysql_error() . "</P>");
      exit();
    }
 ?>

######################################################################
output random row

<?php
 print "<b>$rndm[titletext]</b>\n";
 ?>

######################################################################

 but am not getting anything when output with PHP in a browser. I am working
off localhost on a WINXP machine. PHP 4.2.2.

Cheers 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php