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').") LIMIT 5";
$Result = mysqli_query($Con,$SQL);
while($row = mysqli_fetch_array($Result)) {
  echo $row['keyword'];
  echo "<br>";
}


//To get randon record for current year
$SQL="SELECT keyword FROM `contribu_yummy`.`keywords` ORDER BY RAND(".date('Y').") LIMIT 5";
$Result = mysqli_query($Con,$SQL);
while($row = mysqli_fetch_array($Result)) {
  echo $row['keyword'];
  echo "<br>";
}
?>

Comments

Popular posts from this blog

Login with facebook using coldfusion

Create CSV file in Coldfusion Using CFFile

Get Previous One Day Data in Sql Server