On Wed, 7 Feb 2001 11:28, enthalpy wrote:
> anyone have example code for randomly grabing an item from a mysql table?
>
Mysql 3.23 will let you order by RAND() and you could use a LIMIT to
restrict to one result. I haven't tried it, though.
--
David Robley | WEBMASTER & Mail List Admin
RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/
AusEinet | http://auseinet.flinders.edu.au/
Flinders University, ADELAIDE, SOUTH AUSTRALIA
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]