Yes another question ... I thank all that have taken to help me learn these
new things.
I want to display 10 records per page and allow the user to move on to the
next page of new records. The code below allows me to move to the second
page of records but not any further. I can't seem to think what else needs
to be added or modified to get this to function correctly. Any thoughts?
Again, thanks in advance for any input.
Code:
if ($execute || $nextpg) {
if ($person == "-" && !$nextpg) {
$error = "Please select your name!";
} elseif ($magicword != "pw" && !$nextpg) {
$error = "Please enter correct password!";
} else {
$execute = "good";
$db = mysql_connect("localhost","username","pw");
mysql_select_db("countryloft");
if (!$nextpg) {
$i = 0;
} else {
$i = $i+10;
}
// count number of new requests
$resource = mysql_query("SELECT COUNT(*) cnt FROM
catalogs WHERE PROCESSED IS NULL");
$countreq = mysql_fetch_array($resource);
// get requests from table
$result = mysql_query("SELECT * FROM catalogs WHERE
PROCESSED IS NULL LIMIT $i,10");
if (!$nextpg) {
echo "Total Requests: $countreq[cnt]\n";
}
echo "<table border=1 width=700>\n";
echo
"<tr><td></td><td><u><b>Name</b></u></td><td><u><b>Address</b></u></td><td><
u><b>City</b></u></td><td><u><b>State</b></u></td><td><u><b>Zip
Code</b></u></td><td><u><b>Country</b></u></td><td><u><b>E-Mail</b></u></td>
</tr>\n";
$reqcount = 0;
while ($myrow = mysql_fetch_row($result)) {
$reqcount = $reqcount+1;
printf("<tr><td
bgcolor=\"#FFFF99\">$reqcount<td>%s
%s</td><td>%s<br>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</
td></tr>\n",
$myrow[0],$myrow[1],$myrow[2],$myrow[3],$myrow[4],$myrow[6],$myrow[5],$myrow
[7],$myrow[8]);
}
echo "</table>\n";
echo "<br><a href=\"$PHP_SELF?nextpg=good?i=$i\">Next
Page</a>\n";
}
}
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
