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.
And thanks very much to eve
If you change the $_POST to &_REQUEST in this piece of code
$author_name = $_POST["author_name"];'
To make it
$author_name = $_REQUEST["author_name"];'
Should fix that issue
Bastien
Sent from my iPod
On Jan 23, 2010, at 4:26 PM, Joe Keenan
wrote:
This is all that results from the i
This is all that results from the included script on the 2nd display
page:
Articles by
(There are 0 articles in the database.)
Nexta> >>
Given that the where clause in the original query is "WHERE
author_name = '$author_name' " I cannot see how passing the
author_name in the
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
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
