Put No. of guestbook entrys on index

Hey again,
i want to put the number of guestbook entrys in the index of my website, on the front page, how can i do that!

Put this in a file called total.php then put the file into the guestbook folder

view plain copy to clipboard print ?

<?php
include_once "./admin/config.inc.php";
include_once "./lib/mysql.class.php";
ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);
if(ereg(":",$GB_DB['host']))
{
list($host,$port) = explode(":",$GB_DB['host']);
$port = $port;
}
else
{
$port = 3306;
}
if ($dbc = @mysql_connect ($GB_DB['host'].":".$port, $GB_DB['user'], $GB_DB['pass']))
{
if (!@mysql_select_db ($GB_DB['dbName'], $dbc))
{
die ('Could not select the database because: '.mysql_error().'');
}
}
else
{
die ('Could not connect to MySQL because: '.mysql_error().'');
}
$query = "select count(*) as total from ".$GB_TBL['data'];
$thetotal = mysql_query($query);
$row = mysql_fetch_array($thetotal);
$total = $row['total'];
echo $total;
mysql_close($dbc);
?>

then include that file where you want the total to appear using

view plain copy to clipboard print ?

<?php include("path/to/guestbook/total.php"); ?>

changing the path/to part to reflect your servers directory structure.

Just remember that this will query your database everytime somebody views the page it's included on and if you are on a host that limits MySQL queris you could be in trouble.