Postgres Pro
Downloads
Home   >   mailing lists

FW: Random Selection from TABLE - Mailing list pgsql-novice

From Kris-Jon Fenton
Subject FW: Random Selection from TABLE
Date
Msg-id EPEFICNFACCLFNPJCLLJCEKFCDAA.kfenton@pcpro.net.au
Whole thread Raw
Responses Re: FW: Random Selection from TABLE
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Storing number '001' ?
Next
From: "Josh Berkus"
Date:
Subject: Re: FW: Random Selection from TABLE