Random record

[joe]

Does anyone have any good ideas on how to pull a random record? I've been using PHP's 
random function to create a random number to pull, but the problem is that if I delete 
a record, it could still try to pull it.  Is there a better way?  I'd really like to 
be able to just pull it in the SQL statement instead of pulling a bunch of records 
then sorting throught that.

Thanks,

JOE