title: How to change in rand(?)?
body: <p>I have a problem by ordering item in my page.
  I want the item to be ordered randomly but to change every day.
  I use ORDER by rand() code and in the () I want todays date to be displayed.
  example if today is 10.12.2020 I want to be in my code ORDER by rand(10).
  This is my code</p>
  <pre><code>include(&quot;pagination/function.php&quot;);
  
   $page = (int) (!isset($_GET[&quot;page&quot;]) ? 1 : $_GET[&quot;page&quot;]);
        $limit = 12; //if you want to dispaly 10 records per page then you have to change here
        $startpoint = ($page * $limit) - $limit;
        $statement = &quot;product  ORDER by rand()&quot;; //you have to pass your query over here
  
  
   $res=mysqli_query($link,&quot;select * from product {$statement} LIMIT {$startpoint} , {$limit}&quot;);
   while ($row=mysqli_fetch_array($res))
   {
  </code></pre>