Untitled

<html>
<head>
<basefont face="Arial">
</head>
<body>

<?php

// set database server access variables:
$host = "localhost";
$user = "root";
$pass = "09k6CcsGxBq7p";
$db = "userslogin";

// open connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

// create query
$query = "SELECT * FROM `comments` ORDER BY 1 DESC LIMIT 0 , 5";
// execute query
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

// see if any rows were returned
if (mysql_num_rows($result) > 0) {
    // yes
    // print them one after another

	   echo "<table cellpadding=10 border=1 align=center >";
    while($row = mysql_fetch_row($result)) {
        echo "<tr>";
        echo "<td>".$row[1]."</td>";
        echo "<td>" . $row[2]."</td>";
		echo "<td>". $row[3]."</td>";
        echo "</tr>";
    }
      echo "</table>";

}
else {
    // no
    // print status message
    echo "No rows found!";
}

// free result set memory
mysql_free_result($result);

// close connection
mysql_close($connection);

?>

</body>
</html>