select a random record

From: Peter Kirk <peter_kirk_at_alpha-gruppen.dk>
Date: Thu, 5 Sep 2002 14:19:56 +0200
Message-ID: <3d774bee$0$155$edfadb0f_at_dspool01.news.tele.dk>


Hi there

I need to select a random record from a table in the database.

The table contains data representing pictures for display on a website. One of the characteristics is the "online status". I need to select one random picture-record which status "published". How do I do this?

Thanks,
Peter Received on Thu Sep 05 2002 - 14:19:56 CEST

Original text of this message