Re: Pagination II
- From: "J. Gleixner" <glex_no-spam@xxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 13 Aug 2007 14:34:40 -0500
webmaster@xxxxxxxxxxxxxxxx wrote:
Thanks to everyone here, I am closer to getting this working but am[...]
still having a problem....
The script runs and outputs a page, but in the db I have set up all of
the categories have enough entries to fill multiple pages. So, the
script runs and always goes to page 2 for some reason.
And if I click on one of the other links for a different page, then I
get nothing on that one.
Can anyone spot the problem?
if (!$limit) {$limit = 5;}
$limit = 5 unless defined $limit;
my $sql = "select * from valley where category like ?";
Do you really need all of the columns?
my $sth = $dbh->prepare($sql) or die("Error in SQL1\n");
$sth->execute($find) or die "Error in SQL2 $!\n";
Look at DBI's RaiseError.. Using that you
can eliminate all of your 'or die..' code.
my $results_per_page = 5;
my $sql = "select * from valley where category like ?
limit $limit, $results_per_page";
Start with your SQL, once it's correct, then print it
to make sure it's correct, then actually run it.
print $sql;
Then run it on your DB, to see what it products. It looks like
limit and results_per_page are both 5, which probably isn't
what you want.
$sth->bind_columns( \$ID, \$category, \$name, \$description, \
$contact, \$phone, \$fax, \$address, \$city, \$state, \$zip, \$email, \
$url, \$keywords );
A little more readable as:
$sth->bind_columns( \( $ID, $category, $name, ..., $keywords ) );
.
- Follow-Ups:
- Re: Pagination II
- From: JimJx
- Re: Pagination II
- References:
- Pagination II
- From: webmaster
- Pagination II
- Prev by Date: Re: perl DBI OO
- Next by Date: Re: Regular Expression: Perl and vi
- Previous by thread: Pagination II
- Next by thread: Re: Pagination II
- Index(es):
Relevant Pages
|
