You should not rely on the autonumber as a sorting method. You should use it
as a reference. I see you have two easy options (there may be more, but this
seems suitable).

1. Get the SQL to pull a random record (requires mySQL 3.23.x or higher)
            SELECT * FROM tblName ORDER BY RAND() LIMIT 1

2. Get all of the ID numbers into an array and pick a random value, then
retrieve the rest of the details using the row ID you picked from the array.


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to