To display a random entry from a MySQL database we need to use a MySQL function rand(). To display the entry from MySQL database in PHP following script is used:

<?php
//connect to server with username and password,
$connection = mysql_connect ("localhost","root", "root") or die ("Cannot make the connection");
//connect to database
$db = mysql_select_db ("demo",$connection) or die ("Cannot connect to database");
//our SQL query
$sql_query = "SELECT * FROM test ORDER BY RAND() LIMIT 1";
//store the SQL query in the result variable
$result = mysql_query($sql_query);
if(mysql_num_rows($result))
{
//output as long as there are still available fields
while($row = mysql_fetch_row($result))
{
print_r($row);
}
}
//if no fields exist
else
{
echo "no values in the database";
}

?>