RE: [PHP-DB] Pulling random HTML code out of a table

I didn't know SQL had random number selection, but I could well be wrong about that. Personally I'd use the math functions of PHP to determine the random number and then use something like WHERE CodeID=RandomIDNumber. Have a quick squint at http://www.php.net/manual/function.rand.php for more info on this. Cheers Jon -----Original Message----- From: Mattias Johansson [mailto:smart@smartsmartsmart.com] Sent: 03 January 2001 17:38 To: php-db@lists.php.net Subject: [PHP-DB] Pulling random HTML code out of a table Okay, this is the scenario: I have a table with two columns. One called CodeID and one called code. In the code column is HTML code. (duh) Now, I want to create a query which chooses a random CodeID and pulls out the code associated with it. I then simply echo the code unto the web page. How do I make the query? Really, really thankful for an answer! /Mattias -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net