<?php
// Put database connection variables here
$hostname='localhost';
$user='xxxxx'; //'user name to access database';
$pass= 'xxxxx'; //'password';
$dbase='xxxxx; //'database name';

$connection = mysql_connect("$hostname" , "$user" , "$pass") or die ("Can't connect to MySQL");
$db = mysql_select_db($dbase , $connection) or die ("Can't select database.");

$q = "SELECT * from blog order by date desc ";
$result= mysql_query($q, $connection) or die
("Could not execute query : $q." . mysql_error());


// dynamic navigation variables
$rows_per_page= [B]10[/B];   // adjust the number here to display number of entries per page
$total_records=mysql_num_rows($result);
$pages = ceil($total_records / $rows_per_page);

$screen = $_GET["screen"];
if (!isset($screen))
$screen=0;
$start = $screen * $rows_per_page;
$q .= "LIMIT $start, $rows_per_page";
$result= mysql_query($q, $connection) or die
("Could not execute query : $q." . mysql_error());


while ($row=mysql_fetch_array($result))
{
$id=$row["id"];
$name=$row["name"];
$email=$row["email"];
$entry=$row["entry"];
$date=$row["date"];
$icon=$row["icon"];
$title=$row["$title"];

?>

<table width="80%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><b><?php echo "$title"; ?></b></td>
</tr>
<tr>
<td>
<p><img src="<?php echo "$icon"; ?>" alt="icon" align="left"><?php echo "$entry"; ?></p>
<p><a href="mailto:<?php echo "$email"; ?>"><?php echo "$name"; ?></a> Cried at <?php echo "

$date"; ?>.</p>
</td>
</tr>
</table>
<p align="right">

<?php

$query = "select id from blog_comments where blog_id=`$id` ";
$ret = mysql_query($query) or die (mysql_error());
$comment_num = mysql_num_rows($ret);

// display number of comments
echo "<a href=\"readcomments.php?id=$id\">$comment_num</a>";

?>

</p>
<?php
} #while
?>
<div align=center>

<?php

// Display dynamic navigation here

// create the dynamic links
if ($screen > 0) {
$j = $screen - 1;
$url = "display.php?screen=$j";
echo "<a href=\"$url\">Prev</a>";
}

// page numbering links now

for ($i = 0; $i < $pages; $i++) {
$url = "display.php?screen=" . $i;
$j = $i + 1;
echo " | <a href=\"$url\">$j</a> | ";
}

if ($screen < $pages-1) {
$j = $screen + 1;
$url = "display.php?screen=$j";
echo "<a href=\"$url\">Next</a>";
}

?>

</div>