Pagining Problem

[ldd76]

Hi

I am using PHP4,MYSQL on IIS5.

I have a problem with paging. I set the page limit to 10 records per page. However, the result displayed on all pages are the same. It just followed the results from the first page. Anyone knows why? Thanks

here is my code:

$db = mysql_connect("localhost","root","root");

if(!$db){
print("Could not connect to database. Please try again later.");
exit;
}

mysql_select_db("lms");

$limit=10;

$query = "SELECT * from emp";

$numresults = mysql_query($query);

$numrows = mysql_num_rows($numresults);

print("<br>$numrows</br>");

if (empty($offset)) {
$offset=1;
}

$query = "SELECT * from emp order by icnum limit $offset,$limit";

$result = mysql_query($query);

while ($row=mysql_fetch_array($result)) {

print( "<tr><form method = \"post\"
action = \"deleteRecByname.php\">
<td>" .(stripslashes($row["icnum"])). "</td>
<td>" .(stripslashes($row["empname"])). "</td>
<td>" .(stripslashes($row["address"])). "</td>
<td>" .(stripslashes($row["jobtitle"]))."</td>
<td>" .(stripslashes($row["datejoin"]))."</td>
<td>" .(stripslashes($row["dept"])). "</td>
<td>" .(stripslashes($row["sex"])). "</td>");
print("</form>");

}

if ($offset==1) {
$prevoffset=$offset-20;
print "<a href=\"$PHP_SELF?offset=$prevoffset\">PREV</a> &nbsp; \n";
}

$pages=intval($numrows/$limit);

if ($numrows%$limit) {
$pages++;
}

for ($i=1;$i<=$pages;$i++) {
$newoffset=$limit*($i-1);
print "<a href=\"$PHP_SELF?offset=$newoffset\">$i</a> &nbsp; \n";
}

if (!(($offset/$limit)==$pages) && $pages!=1) {
$newoffset=$offset+$limit;
print "<a href=\"$PHP_SELF?offset=$newoffset\">NEXT</a><p>\n";
}

[tekky]

1) PHP tags make code easier to read here.... as it colorizes it...

2) try

$offset = $_GET['offset'];

[ldd76]

Thanks Tekky...It works🙂

But why does I need to use the $_GET command to extract the offset varaible value... It should be auto isn't it.

[tekky]

because as of PHP 4, superglobals are turned off by default, so now you have to use the $_SERVER/SESSION/COOKIE/GET/POST variables to access them, there are ways to make PHP still function in a simliar fashion

such as the extract() function

[ldd76]

Thanks..U are very helpful🙂