Get random records from mysql
Get random records from mysql. To get randon records for current day and for current year using by order by rand() function. <?php //Connect To database $Con=mysqli_connect("127.0.0.1","root","pinturp1","contribu_yummy"); //To get randon records $SQL="SELECT keyword FROM `contribu_yummy`.`keywords` ORDER BY RAND() LIMIT 5"; $Result = mysqli_query($Con,$SQL); while($row = mysqli_fetch_array($Result)) { echo $row['keyword']; echo "<br>"; } //To get randon record for current day $SQL="SELECT keyword FROM `contribu_yummy`.`keywords` ORDER BY RAND(".date('Ymd').") LIMIT 5"; $Result = mysqli_query($Con,$SQL); while($row = mysqli_fetch_array($Result)) { echo $row['keyword']; echo "<br>"; } //To get randon record for current month $SQL="SELECT keyword FROM `contribu_yummy`.`keywords` ORDER BY RAND(".date('Ym')....