Re: Paging
| From: | Bastien Koert | Date: | Wed, 13 May 2009 13:11:41 +0000 |
| Subject: | Re: Paging | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46187@lists.php.net to get a copy of this message | ||
On Mon, May 11, 2009 at 9:07 PM, Joey Hendricks
<j.hendricksjr@comcast.net>wrote:
> Hi everybody, I have a paging question. I have a page where you can view a
> persons 'profile'. And I have a list taken from the db of there books. I can
> get all the books on one page but I can't figure out the WHERE from the get.
> This is what I tried but it didn't work.
> $query = "SELECT COUNT(*) AS numrows FROM tabs WHERE user_name='".$_GET
> ['user_name']."';
> $data = mysqli_query($dbc, $query) or die('Error, query failed');
> $row = mysqli_fetch_array($data);
> $numrows = $row['numrows'];
>
> When I do this it shows a second page but when I click on the next page It
> goes to my profile or the user who is logged in, not the users profile I was
> looking at on page 1. Thanks every one for all your help!!
Can you post the code snippets for the sections that matter?
Also, have a look at the variables you are calling, maybe one is overwriting
the other
--
Bastien
Cat, the other other white meat