PDA

View Full Version : Random Items


savingc
Fri 4th Oct '02, 10:56am
I have a Hot Deals and Internet codes site and need to pull one item form the Mysql database each day to be a "Deal of the Day". Any ideas how I can do this??


www.saving-cents.com

At the bottom is where I want it to go.

Chen
Fri 4th Oct '02, 11:19am
Use SELECT * FROM tblName ORDER BY RAND() LIMIT 1 to get a random record.

savingc
Fri 4th Oct '02, 11:27am
Ok dumb blonde question time..how exactly is that written?