At 15:32 -0600 3/8/03, Darren Young wrote:
3.23.54 on Linux.
And it worked. Thx. Seems to be "not so random", but then with more
records to sample from the "randomness" would increase. True?
Probably. However, if you check the change notes in the manual for
3.23.56, 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 wrote:
I have a table called testimonials:
+----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+----------------+
| id | tinyint(3) | | PRI | NULL | auto_increment |
| can_use | tinyint(1) | | | 0 | |
| name | varchar(64) | | | 0 | |
| location | varchar(64) | | | 0 | |
| quote | text | | | | |
+----------+-------------+------+-----+---------+----------------+
That contains 20 or so "customer testimonial" comments. I want to
randomly display 3-4 of them every time a page loads (using PHP). Is
there some type of random selction available within MySQL, as in:
SELECT RANDOM(id),name,location,quote FROM testimonials WHERE
can_use=1 LIMIT 3;
Or something to that effect or am I better served finding some way in
PHP to do this?
.... ORDER BY RAND() LIMIT 3
ought to do it, unless your version of MySQL is older than 3.23.2.
>Thanks.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
