[PHP] Random Record Retrieval

How's that for alliteration in a subject line? Got a simple MySQL 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

Re: [PHP] Random Record Retrieval

Robb Kerr wrote: 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. SELECT * FROM table ORDER BY RAND() LIMIT 1 -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

Re: [PHP] Random Record Retrieval

How about rand() on your ID column. http://www.php.net/manual/en/function.rand.php How's that for alliteration in a subject line? Got a simple MySQL 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