showing total pages in navigation?

[TSniperManiac]

Please i need advice.

I want to print total pages and i'am using 7 rows on each screen.

It all went well as long as i had 6 pages but after posting a new post so i got 7pages. it looks like this

total pages: 6.2857142857143

How do i modify it so it writes total pages: 7 with no extra numbers after.???

Anyway is a bit hard to explain so here is the code. I hope you will understand my cryptic wrtiting. ;-)

<?
// Pages Total.
include("db.settings.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query3=mysql_query("SELECT * FROM news");
mysql_close();

                    $numrows3=mysql_num_rows($query3); 
                    $pagestotal = ($numrows3/7);             
               {
                    echo " <b>".$pagestotal."</b>"; 
               }

?>

[Mordecai]

ceil(). All it does is round up, and always up.

[TSniperManiac]

Originally posted by Mordecai
ceil(). All it does is round up, and always up.

and the help was? please if you have a better a idea how to do it,
please help me, thank you.

here is the code again as it is changed:

<?
// Pages Total.
include("db.settings.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query3=mysql_query("SELECT * FROM news");
mysql_close();

$numrows3=mysql_num_rows($query3);
$pagestotal = ($numrows3/7) + 1;
{
echo " <b>".$pagestotal."</b>";
}
?>

how do i get it to post only 7 with no numbers after it.

[laserlight]

ceil() was recommended, use it.

$pagestotal = ceil($numrows3 / 7);
echo " <b>".$pagestotal."</b>";

[TSniperManiac]

i dont understand ceil() ???

and the posted response did not help. sorry.
please advice. and thanx for all answers. ;-)

[laserlight]

<?php
/**
 * This is a bogus example of how to count the total number of pages
 *  in a database table, where each page consists of a certain number
 *  of rows, or part thereof.
 * We shall connect to and select the mysql database to start
 **/

$rows_per_page = 10; //you might change this to 7
$db = mysql_connect("localhost", "username", "password")
	OR die("Error: cannot connect to database!");
mysql_select_db("database_name", $db)
	OR die("Error: cannot select database!");

//assume there is an 'id' index in table 'tablename'
$query = mysql_query("SELECT id FROM tablename");
$total = mysql_num_rows($query);
$pages = ceil($total / $rows_per_page);
//wow, now $pages contains the total number of pages!

//release the member associated with the query
mysql_free_result($query);
//then disconnect, since you apparently wish to do so explicitly
mysql_close($db);
?>

Well, why use ceil()?
Consider
n: number of rows
p: number of pages
For the case of 5 pages per row,

n=0 => p = ceil(0/5) = 0
n=1 => p = ceil(1/5) = 1
n=2 => p = ceil(2/5) = 1
n=3 => p = ceil(3/5) = 1
n=4 => p = ceil(4/5) = 1
n=5 => p = ceil(5/5) = 1
n=6 => p = ceil(6/5) = 2
n=7 => p = ceil(7/5) = 2
n=8 => p = ceil(8/5) = 2
n=9 => p = ceil(9/5) = 2
n=10 => p = ceil(10/5) = 2
n=11 => p = ceil(11/5) = 3

isnt that the required result?

[TSniperManiac]

That did the trick. thanx alot.

You have helped me alot, not only with the code but to understand som more about the algorithms of PHP ;-)

thanx for the nice presentation of ceil.

To all other do not respond, this code has ben taken care of
by laserlight. 😃