Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group