Code:
SELECT * FROM cd_spotlight WHERE approved>0 ORDER BY RAND() LIMIT 1
I've found (and now you) that mysql rand() function isn't too random. I will be changing it slightly soon, to hopefully be a bit more random.
[EDIT]ok, its changed. Hopefully it'll be a bit more random.[/EDIT]