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 FROM AS r1 JOIN (SELECT ROUND( RAND( ) * ( SELECT MAX( id ) FROM ) ) AS id ) AS r2 WHERE r1.id >= r2.id ORDER BY r1.id ASC LIMIT 1; Replace: <COLUMN> [...]