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 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), author varchar(20), body text, primary key(id));
>
> Ok, so then I just inserted some random data into to test with.
>
> Here is some PHP code:
> <?php
> $link = mysql_connect('localhost', 'user', 'password');
> mysql_select_db("database", $link);
> $result = mysql_query("SELECT * FROM table", $link);
> $num_rows = mysql_num_rows($result);
> $all = array();
> while ($topic = mysql_fetch_assoc($result)) {
> $all[] = $topic;
> }
> if (isset($_GET['start'])) {
> $start = $_GET['start'];
> } else {
> $start = 0;
> }
> for($i = $start; $i < $start + 15; $i++) {
> echo "Topic ID: ". $all[$i]['id'] ."<br />";
> echo "Topic Title: ". $all[$i]['topic'] ."<br />";
> echo "Topic Author: ". $all[$i]['author'] ."<br />";
> echo "Topic Body: ". $all[$i]['body'] ."<br />";
> echo "<hr>";
> if ($i == $start + 14) {
> echo "<p><a href=\"pages.php?start=".($i+1)."\">Next
> Page</a></p>";
> }
> }
> mysql_free_result($result);
> mysql_close($link);
> ?>
>
> That will do simple paging, and works seems to work fine.
>
>
> On Tue, 2004-09-28 at 22:05, Nick Patsaros wrote:
> > I'm trying to build a bulletin style system right now. I have topics
> > and replies to each topic. If a topic gets more than 15 replies I
> > want them to start carrying over onto page 2 and then 3 and so on with
> > 15 replies per page.
> >
> > The key that I'm missing I guess is, how do I keep track of the last
> > accessed row in the database? So if I run a LIMIT 15 I can go back
> > and pick up where I left on previously? Using the primary key isn't
> > going to help because if posts get deleted I would have less than 15
> > per page.
> >
> > Maybe I'm totally lost on this though, if someone could give me a bit
> > of help on the most efficient way to accomplish this.
> >
> > --Nick
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
