NamePros.Com - View Single Post - Randomingly choosing a quote from Database, PHP

10-28-2005, 06:56 PM

· #3

sdsinc

Domains my Dominion

Name: Kate

Location: Expat

Trader Rating: (58)

Join Date: Aug 2005

Posts: 5,597
NP$: 1710.11 (Donate)

Easy:

select [field] from [table]
order by rand()
limit 1

and you fetch one random record at a time

Please register or log-in into NamePros to hide ads

10-28-2005, 06:56 PM	· #3
sdsinc Domains my Dominion Name: Kate Location: Expat Trader Rating: (58) Join Date: Aug 2005 Posts: 5,597 NP$: 1710.11 (Donate)	Easy: select [field] from [table] order by rand() limit 1 and you fetch one random record at a time Please register or log-in into NamePros to hide ads