Joe Keenan wrote:
Thanks very much Bastien. I haven't the faintest idea why but that
simple change in the code sorted all of this. The pagination links now
follow through with the complete result set of my query.
I will now have to read around this to discover why the change works.
By puttin
fore "author_name". there should only be
one. also, if your author's name includes a space, you'll need to
deal with that.
- Rick
-------- Original Message ----
Date: Saturday, January 23, 2010 08:23:23 PM +
From: Joe Keenan
To: Edward Brookhouse
Cc: php-d
- Rick
------------ Original Message ----
Date: Saturday, January 23, 2010 08:23:23 PM +
From: Joe Keenan
To: Edward Brookhouse
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] result set in php pagination
I have tested the script with echo() which shows that the correct
$numrows i
- Rick
Original Message ------------
Date: Saturday, January 23, 2010 08:23:23 PM +
From: Joe Keenan
To: Edward Brookhouse
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] result set in php pagination
I have tested the script with echo() which shows that the correct
$numr
I have tested the script with echo() which shows that the correct
$numrows is returned and then
$totalpages = ceil($numrows / $rowsperpage);
Everything is correct on the first page of results. The pagination
links are displayed correctly but when clicked on the resulting page
is empty.
F
I have tried adding the name to the pagination url which gave me
"http://..results_1.php?currentpage=2&&author_name=Editorial";
Once again no further results were returned. The pagination urls were
in place but empty, no pages existed for them.
coding sessions in this context is beyond
The easiest thing to do is either
A) store the author name in a session for the duration of the searches
B) add the name to the pagination url so that its passed along withe
the page number
On 1/23/10, Joe Keenan wrote:
> I am using php and mysql.
>
> The problem which I am hoping someone can
