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? 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
