Hello James,
You're passing you 'i' parameter to the URL incorrectly. PHP splits
the paramer list into separate elements by looking for & characters,
examining each element for the equal sign. Note this line, towards
the end of the code:
echo "<br><a href=\"$PHP_SELF?nextpg=good?i=$i\">Next ....
You're separating the 'nextpg' and 'i' with a question mark. Change
to this & and you should be all set.
Regards,
James Chin
Technical Support Consultant
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
On Fri, 18 Jan 2002 14:02:51 -0500, [EMAIL PROTECTED] (James Kupernik)
wrote:
>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]
