<> tutorial at phpfreaks.com:
http://www.phpfreaks.com/tutorials/73/0.php
HTH
Graham.
-Original Message-
From: Silvio Porcellana [mailto:[EMAIL PROTECTED]
Sent: 29 September 2004 10:53
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Multiple pages of data.
You can solve it totally wi
You can solve it totally with SQL, using the FOUND_ROWS() function
[http://dev.mysql.com/doc/mysql/en/Information_functions.html]
I think this is the most efficient way of doing it...
HTH, cheers
Silvio Porcellana
Nick Patsaros wrote:
I'm trying to build a bulletin style system right now. I have
oops, forgot to add this, put as first line in the for loop:
if ($i == $num_rows) break;
On Tue, 2004-09-28 at 22:45, Matthew Fonda wrote:
> Or if you wanted to do it all in PHP, without using LIMIT, you could do
> something like this.
>
> I'm not exactly sure how your database is set up, so I ju
Or if you wanted to do it all in PHP, without using LIMIT, you could do
something like this.
I'm not exactly sure how your database is set up, so I just used this
made this dummy table as the one I will use in this example:
create table topics(id int(8) not null auto_increment, topic
varchar(30),
Your not totally lost on it, your very cloes to your solution. Keep
track of the LIMITs with php, and not mysql. Pass the LIMIT
information to the next page, and use some aritihitc to determine the
next and prvious limits for the link...
so you would have a var called $limit possibly, and your n
5 matches
Mail list logo
