workaround. :-)
Hope that helps.
Matt
- Original Message -
From: "Jay Paulson"
Sent: Thursday, August 28, 2003 2:57 PM
Subject: Random Selects
Hello-
I'm trying to get random information out of my table and the query I'm
using keeps returning the same row every time. I
Hello-
I'm trying to get random information out of my table and the query I'm using keeps
returning the same row every time. In the table I have 3 rows and I want to choose at
random in the sql which row to return. Here's an example query I have.
SELECT * FROM banner ORDER BY rand() asc limit
you'll see that RAND() initialization was modified to be
more random for new connections.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 08, 2003 2:33 PM
To: Darren Young; [EMAIL PROTECTED]
Subject: Re: Random Selects
At 12:33 -0600 3/8/03, Darren Young wro
ng; [EMAIL PROTECTED]
Subject: Re: Random Selects
At 12:33 -0600 3/8/03, Darren Young wrote:
>I have a table called testimonials:
>
>+--+-+--+-+-++
>| Field| Type
At 12:33 -0600 3/8/03, Darren Young wrote:
I have a table called testimonials:
+--+-+--+-+-++
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-++
| id | tinyi
I have a table called testimonials:
+--+-+--+-+-++
| Field| Type| Null | Key | Default | Extra |
+--+-+--+-+-++
| id | tinyint(3) | | PRI | NULL| auto_incre
