How's that for alliteration in a subject line? Got a simple table that contains records which are made up of only three fields - ID, quote and author. These are "inspirational" quotes that I want to appear at the bottom of the pages of my website. I want them to come up randomly with every page load. How do I randomly access records from a table?
I thought about building a random number generator in PHP that selects a random number out of the total number of records in the table, saves it into a variable and then have MySQL retrieve that ID. Is this the way to go or is there something simpler. Unfortunately I don't know how to write a random number generator in PHP. Thanx in advance, Robb -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
