select and display random records using php and mysql

To select and display random records using php and mysql is very easy. Just we need to do is to write this query instead of simple select query.

$select_query="select * from student order by rand()";

Now every time this query after execution comes with random records. So this is the way to select and display random records.