Re: Random Record Retrieval

2004-05-22 Thread Michael Stassen
mos wrote: At 05:08 PM 5/22/2004, you wrote: Robb Kerr wrote: 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 wi

Re: Random Record Retrieval

2004-05-22 Thread mos
At 05:08 PM 5/22/2004, you wrote: Robb Kerr wrote: 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

Re: Random Record Retrieval

2004-05-22 Thread Hassan Schroeder
Robb Kerr wrote: 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 re

Re: random record

2003-09-15 Thread Michael Brunson
I just checked... 83 On Mon, 15 Sep 2003 13:54:53 +0100, "Andy Eastham" <[EMAIL PROTECTED]> wrote: | 39? | | > -Original Message- | > From: tuncay bas [mailto:[EMAIL PROTECTED] | > Sent: 15 September 2003 13:32 | > To: mysql | > Subject: random record | > | > | > hi, | > | > why its

Re: {Scanned} RE: random record

2003-09-15 Thread Henry Wong
pls unsubscribe me from this maillist. thanks. - Original Message - From: "Andy Eastham" <[EMAIL PROTECTED]> To: "Mysql List" <[EMAIL PROTECTED]> Sent: Monday, September 15, 2003 8:54 PM Subject: {Scanned} RE: random record > 39? > > > ---

RE: random record

2003-09-15 Thread Andy Eastham
39? > -Original Message- > From: tuncay bas [mailto:[EMAIL PROTECTED] > Sent: 15 September 2003 13:32 > To: mysql > Subject: random record > > > hi, > > why its mysql database over random record use? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To uns

RE: Random record

2001-02-26 Thread Alan Halls
You have to have version 3.23 of mysql and then you can add ORDER BY RAND() to the end of your query. Alan -Original Message- From: joe [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 25, 2018 4:40 PM To: MySQL Subject: Random record Does anyone have any good ideas on how to pull a r

Re: Random record

2001-02-25 Thread ryc
Instead of pulling using equals, ie "select * from table where id = $php_random_variable" you can do this instead "select * from table where id <= $php_random_variable LIMIT 1"... As long is there is atleast one row in the table you will get back a result. Hope that helps. ryan - Original Me

RE: Random record

2001-02-25 Thread Cal Evans
Check the archives. The answer you seek is there. Cal http://www.calevans.com -Original Message- From: joe [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 25, 2018 5:40 PM To: MySQL Subject: Random record Does anyone have any good ideas on how to pull a random record? I've been usi

RE: Random record from a table

2001-02-24 Thread Cal Evans
Check the archives, we had this discussion a few weeks ago and someone came up with a good solution. Cal http://www.calevans.com -Original Message- From: Sheni R. Meledath [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 24, 2001 9:05 AM To: MySQL Masters Subject: Random record from