Random Items

[savingc]

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]

Use SELECT * FROM tblName ORDER BY RAND() LIMIT 1 to get a random record.

[savingc]

Ok dumb blonde question time..how exactly is that written?