Paging- problem...

[Hulio]

Is there anyone, who could give me a solution for this problem: My paging is working fine, but only the pageorder is wrong. The newest written item should set to the first page but it always goes to top of the last page. How could I get it working so that the newest items are always on the top of the first page?

Code:

<?php

include("MySQL.php");

mysql_connect($mysql_server,$mysql_user,$mysql_pass);
mysql_selectdb($mysql_db);

class Pager
{
function getPagerData($numHits, $limit, $page)
{
$numHits = (int) $numHits;
$limit = max((int) $limit, 1);
$page = (int) $page;
$numPages = ceil($numHits / $limit);

$page = max($page, 1);
$page = min($page, $numPages);

$offset = ($page - 1) * $limit;

$ret = new stdClass;

$ret->offset = $offset;
$ret->limit = $limit;
$ret->numPages = $numPages;
$ret->page = $page;

return $ret;
}
}

// get the pager input values
$page = $_GET['page'];
$limit = 20;
$result = mysql_query("select count(*) from Table");
$total = mysql_result($result, 0, 0);

// work out the pager values
$pager = Pager::getPagerData($total, $limit, $page);
$offset = $pager->offset;
$limit = $pager->limit;
$page = $pager->page;

// use pager values to fetch data
$query = "select * from Table order by Id limit $offset, $limit";
$result = mysql_query($query);

// use $result here to output page content

// output paging system (could also do it before we output the page content)
if ($page == 1) // this is the first page - there is no previous page
echo "Previous";
else // not the first page, link to the previous page
echo "<a href=\"thepage.php?page=" . ($page - 1) . "\">Previous</a>";

for ($i = 1; $i <= $pager->numPages; $i++) {
echo " | ";
if ($i == $pager->page)
echo "Page $i";
else
echo "<a href=\"thepage.php?page=$i\">Page $i</a>";
}

if ($page == $pager->numPages) // this is the last page - there is no next page
echo "Next";
else // not the last page, link to the next page
echo "<a href=\"thepage.php?page=" . ($page + 1) . "\">Next</a>";


for($i = mysql_numrows($result); $i > 0; $i--) {
$ii = $i;
$ii--;
echo "<h1>";
echo mysql_result($result,$ii,"Topic");
echo "</h1>";
echo "<p>";
echo mysql_result($result,$ii,"Txt");
echo "</p>";
echo "<p>";
echo mysql_result($result,$ii,"Sender");
echo " - ";
echo mysql_result($result,$ii,"Time");
echo "</p>";
}

mysql_close();

?>

[mansuang]

you may have to put DESC at ORDER BY in SQL statement.

// use pager values to fetch data
$query = "select * from Table order by Id [color=red]DESC[/color] limit $offset, $limit";
$result = mysql_query($query);

[The Little Guy]

$result = mysql_query("select count(*) from Table" ORDER BY DESC);

[Hulio]

That doesn't solve the problem, because the pageorder is right, but the newest items go to the bottom of the first page.

[Hulio]

Or should I just give up and try something else??!

[mansuang]

Try to revise your "for" loop like this.

for($i = [color=Red]$limit[/color]; $i > [color=red]$offset[/color]; $i--) {
$ii = $i;
$ii--;
echo "<h1>";
echo mysql_result($result,$ii ,"Topic");
echo "</h1>";
echo "<p>";
echo mysql_result($result,$ii,"Txt");
echo "</p>";
echo "<p>";
echo mysql_result($result,$ii,"Sender");
echo " - ";
echo mysql_result($result,$ii,"Time");
echo "</p>";
}


Hope it works

[Hulio]

No, it didn't work...it only shows the first page with oldest updated items...

[sasa]

[code]<?php
include("MySQL.php");
.....
// use pager values to fetch data
$query = "select * from Table order by Id DESC limit $offset, $limit"; // <= chamge this line
$result = mysql_query($query);
...
for($ii = 0; $ii < mysql_numrows($result); $ii++) { // change this 3 lines
// $ii = $i;
// $ii--;
echo "<h1>";
echo mysql_result($result,$ii,"Topic");
echo "</h1>";
echo "<p>";
echo mysql_result($result,$ii,"Txt");
echo "</p>";
echo "<p>";
echo mysql_result($result,$ii,"Sender");
echo " - ";
echo mysql_result($result,$ii,"Time");
echo "</p>";
}

mysql_close();

?>[/code]

[Hulio]

THere it is!!! Thanks a lot!