Re: remove from db renumbering

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. Adam