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
ho "";
echo $first . $prev . " Showing page $pageNum of
$maxPage pages " . $next . $last;
?>
-Original Message-
From: Joe Keenan [mailto:heresia...@btopenworld.com]
Sent: Saturday, January 23, 2010 1:16 PM
To: php-db@lists.php.net
Subject: [PHP-DB] result
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
I am using php and mysql.
The problem which I am hoping someone can help me with concerns
pagination of the result set of a search of a single table.
I got the pagination script I am using from a Sitepoint tutorial and
it works just as it should for this query
"SELECT article_id, category
