Announcement

Collapse
No announcement yet.

Random Items

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Random Items

    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.

  • #2
    Use SELECT * FROM tblName ORDER BY RAND() LIMIT 1 to get a random record.
    Chen Avinadav
    Better to remain silent and be thought a fool than to speak out and remove all doubt.

    גם אני מאוכזב מסיקור תחרות לתור מוטור של NRG הרשת ע"י מעריב

    Comment


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

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X