FW: Random Selection from TABLE

From: "Kris-Jon Fenton" <kfenton(at)pcpro(dot)net(dot)au>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: FW: Random Selection from TABLE
Date: 2001-12-20 05:35:32
Message-ID: EPEFICNFACCLFNPJCLLJCEKFCDAA.kfenton@pcpro.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I have a table that simply holds three fields:
serial_id
image_name
image_text

I want to be able to select entries randomly so I can change the images on a
website using PHP.

Basically I need to have a randomly rotating image that will change whenever
the page is refreshed.

I want to store the image names in a table and have them selected from
there.

Using PostgreSQL version 7.1.3-2

Thanks
Kris

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2001-12-20 16:10:44 Re: FW: Random Selection from TABLE
Previous Message Josh Berkus 2001-12-20 00:48:31 Re: Storing number '001' ?