Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

RE: [PHP-DB] Pulling random HTML code out of a table From: Cal Evans (cal <email protected>)
Date: 01/03/01

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 <email protected>]
Sent: Wednesday, January 03, 2001 11:38 AM
To: php-db <email protected>
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 <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>