$db = mysql_connect("localhost", "suhmatausers","lsksir4DDksja21");
mysql_select_db("suhmatadb",$db);
mysql_set_charset("utf8");
?>
$page = (int) $_GET['page']; //From here Page Cuter.*
if($page>1000 || $page<1)
$page=1;
$per_page = 20;
$start = ($page-1) * $per_page;
$query = mysql_query("SELECT count(*) as total FROM `guestbook`") or die(mysql_error());
$row = mysql_fetch_array($query, MYSQL_ASSOC);
$total_num = $row['total'];
$query=mysql_query("SELECT * FROM guestbook where Gnotes=' ' order by ID DESC LIMIT $start, $per_page",$db);
$result = mysql_query ($query) ;
$query2=mysql_query("SELECT * FROM guestbook where Gnotes=' ' order by ID DESC",$db);
$NP = mysql_num_rows($query2) or die ("nothing to show");
if ($NP % 20 == 0) {
$NP = ($NP / 20) ;
}
else {
$NP = ($NP / 20) +1;
}
for ($i = 1;$i <= $NP;$i++) {
echo "
";
echo $i;
echo "";
echo " ";
}
?>
Name |
Comments |
$record=mysql_fetch_array($query);
$c=$start;
while($record){
$c++;
if($c%2==0)
$bgcolor="#D9E4F2";
else
$bgcolor="#C6D7EC";
?>
>
echo $c;?>.

Location:
|
|
$record=mysql_fetch_array($query);
}
?>
$query3=mysql_query("SELECT * FROM guestbook order by ID DESC",$db);
$NP = mysql_num_rows($query3) or die ("nothing to show");
if ($NP % 20 == 0) {
$NP = ($NP / 20) ;
}
else {
$NP = ($NP / 20) +1;
}
for ($i = 1;$i <= $NP;$i++) {
echo "
";
echo $i;
echo "";
echo " ";
}
?>
® All Rights Reserved, ABNAA' SUHMATA Association
Best experienced using
MS Internet Explorer 6.0, Screen is optimised for viewing at 1024 x 768
|