Randomizing posts in word press - by a random seed + a day variable

[maberg]

The following code is working to force wordpress to show posts in a random order.

However, it shows them in the same random order until you end the session or close the browser.   I want to add a variable so that the seed is updated every day, even if the user has not closed their browser. This way it will change from day to day. 

My thought was to create a variable for the day number (1-31) and add that number to the seed value.  But I don't know how to program. Can anyone help me change the following to achieve this? thank you for saving me days of tinkering.

 session_start();

add_filter('posts_orderby', 'edit_posts_orderby');

function edit_posts_orderby($orderby_statement) {

    $seed = $_SESSION['seed'];
    if (empty($seed)) {
      $seed = rand();
      $_SESSION['seed'] = $seed;
    }

    $orderby_statement = 'RAND('.$seed.')';
    return $orderby_statement;
}

 

[Barand]

You could just forget about the session value and

SELECT ... ORDER BY RAND(dayofyear(CURDATE()))

 

Edited September 21, 2021 by Barand

[maberg]

that works. thank you!