> I need to...
> 1 - Select a set of records from a db
> 2 - Return a list of one or two fields from the selected record set in
> random order on a web page.
> Once I have my selected records & fields... say I end up with 20
> after my select query...
> How can I return the selected records in _random_ order ??
SELECT * FROM your_table ORDER BY RAND() LIMIT 20
Will return 20 random rows from your table.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php