https://proxy2.de/forum/posts/list/5.php JForum - http://www.jforum.net i want to put the number of guestbook entrys in the index of my website, on the front page, how can i do that!]]> https://proxy2.de/forum/posts/preList/5015/18060.php https://proxy2.de/forum/posts/preList/5015/18060.php GMT [code]<?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 ('<p>Could not select the database because: <b>'.mysql_error().'</b></p>');
}
}
else
{
die ('<p>Could not connect to MySQL because: <b>'.mysql_error().'</b></p>');
}
$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);
?>[/code]

then include that file where you want the total to appear using[code]<?php include("path/to/guestbook/total.php"); ?>[/code]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.]]> https://proxy2.de/forum/posts/preList/5015/18061.php https://proxy2.de/forum/posts/preList/5015/18061.php GMT