subject:"\[PHP\] Random Record Retrieval"

Re: [PHP] Random Record Retrieval

2004-05-22 Thread Daniel Clark

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

Re: [PHP] Random Record Retrieval

2004-05-22 Thread John W. Holmes

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/ php|arc

[PHP] Random Record Retrieval

2004-05-22 Thread Robb Kerr

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 p