[Displaying random records from a table]

Thanks for your guide. I created a file called test.php as below:

[code]
<?
// file test.php

$db=mysql_connect('localhost','user','pass');
mysql_select_db('database',$db);

$sql = "SELECT * FROM Table_NAME order by round() limit 5";

$result=mysql_query($sql)or die("query round problam");
?>
[/code]

The code seems to be working. BUT there was no display of records!!

I need to incorporate a template to display the 5 random records.

Any idea, please.

[Displaying random records from a table]

Can someone please help me creating a php file for the following codes:

$sql = 'SELECT * FROM library ORDER BY RAND() limit 5;';

where Database is: localhost
Database name is: lib
user: guest2
pass: guest2

Thanks