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

In psuedo code: Find the maximum CodeID. Pick a number between 1 & maxCodeID Select * from tableName where codeID =$selectedCodeID ... you know the rest. I would use PHP to pick the random number. (IMHO) Cal -----Original Message----- From: Mattias Johansson [mailto:smart@smartsmartsmart.com] Sent: Wednesday, January 03, 2001 11:38 AM 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