I've built a page in Dreamweaver (php) pulling records from mysql with
rand() order, displaying 1 record at a time with a navigation pane, it
correctly counts the number in the recordset, but when the user clicks on
the navigation set to go to the next record, it sometimes repeats the
records already shown.

Is there a way to randomly sort a recordset, showing one record at a time,
without repeating the ones shown?

Thanks!