Pulling single random entry from DB

[jaZon]

I'm absolutely clueless. Anyone have any advice/ideas?

[bastien]

getting the count of the records from the db

then generating a random number between 1 and the max then select that record

[man]rand[/man]

hth

[csn]

select *
from table
order by rand()
limit 1;

[jaZon]

thx all.......i got it right after i posted😉