That’s right! I have a simple MySQL class file that you can use in your PHP projects. I’ve been using it for years, and it’s never let me down!
You can grab it on my Github: http://github.com/a1phanumeric/PHP-MySQL-Class.
This is an update to a previous post of mine which uses the RAND() method. Using the following code, you can retrieve a random row much, much faster (MySQL 4.1.x/5.0.x), with thanks to Jan Kneschke:
SELECT <COLUMN> FROM <TABLE> AS r1 JOIN (SELECT ROUND( RAND( ) * ( SELECT MAX( id ) FROM <TABLE>) ) AS id ) AS r2 WHERE r1.id >= r2.id ORDER BY r1.id ASC LIMIT 1;
I’ve tested this with a table with over 660,000 records, and got a response in 0.0200 seconds, whereas with ORDER BY RAND() i got a response in 2.1599 seconds.