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>";
}
?>
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
Post a Comment