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