Results 1 to 2 of 2

Thread: Order by RAND() - once a day

  1. 07/28/2011, 00:08 #1
    wotanskrieg
    wotanskrieg is offline
    User
    Join Date
    10-23-09.
    Posts
    264

    Default Order by RAND() - once a day

    Hi,
    Is it possible with mysql to order items by rand() but only once a day and not on every refresh?

    p.s. I ment this in Catalog list Order by field.
    Web design agency - EDsolution.si Izdelava spletnih strani
    Reply With QuoteReply With Quote
  2. 07/28/2011, 00:22 #2
    wotanskrieg
    wotanskrieg is offline
    User
    Join Date
    10-23-09.
    Posts
    264

    Default Re: Order by RAND() - once a day

    I've found the answer. If anyone would need this here is the solution:
    rand(curdate())

    ops:
    Web design agency - EDsolution.si Izdelava spletnih strani
    Reply With QuoteReply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules