I have made a list page that check list from mysql, like bellow:
$currentpage = "1";
$numbersperpage = "20";
if(isset($_GET['page']) && isset($_GET['numbers'])){
$currentpage = $_GET['page'];
$numbersperpage = $_GET['numbers'];
}
$query_string = "SELECT * FROM payments ";
$check=mysql_query($query_string);
if(ceil(mysql_num_rows($check)/$numbersperpage) < $currentpage){
$currentpage = ceil(mysql_num_rows($check)/$numbersperpage);
}
$query_string_limit = "LIMIT ".(($currentpage - 1) *
$numbersperpage)." , ".$numbersperpage;
ok, when I access the page, there total 60 recorders in database, when
I use
$currentpage = "1";
$numbersperpage = "20";
display the first page and everything is ok, then I try
$currentpage = "2";
$numbersperpage = "20";
is also ok, but when I use
$currentpage = "3";
$numbersperpage = "20";
it comes "Query was empty", any one can help me?
PHP Version 5.2.4
php-5.2.4-win32-installer
mysql-5.0.22-win32
ZendOptimizer-3.3.0a-Windows-i386
Windows2000
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"mysql" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/mysql
-~----------~----~----~----~------~----~------~--~---
