[SOLVED] Fetch array but skip the first few results?

[FridayRain]

I've tried Googling but I must not know the proper words to include. I'm thinking this is simple math. Something like adding 1 to a variable such as $id.

 

My main page will display blog entries, but my right column display the titles of the four most recent pieces from each category, including the blog. Since this column is on every page, there's no need to display blog entries that are already on the front page, so I'd like the query to skip the first three entries and start with the fifth most recent.

 

This is the code for the right column pulling blog entry titles:

 

<?php
require("db/config.php");
require("db/opendb.php");

    $query = "SELECT * FROM blog ORDER BY date DESC LIMIT 4";
    $result = mysql_query($query);

    while($row = mysql_fetch_assoc($result))
        {
        $titlesb[] = "<span>+ </span><a href=\"blogs.php?piece={$row[id]}\">{$row[title]}</a>";
        }

require("db/closedb.php");

    echo implode('<br />', $titlesb);

?>

[Barand]

To get the remaining records use "LIMIT 4, 99999999"

[FridayRain]

...and then what?

[liebs19]

The LIMIT 4, 99999999 will start at the 4th record and select everything else. You won't need to do anything else in your code to skip over them.

[FridayRain]

Hmm. I tried it and all it displayed was the title of the first entry.

[liebs19]

Have you tried echoing out the <span> tags inside the while loop as they are generated instead of storing them in an array and doing an implode? I'm not familiar with the implode command so it might work fine but it could be worth a try.

[FridayRain]

Didn't change anything.

[FridayRain]

Anyone else?

[pocobueno1388]

Change:

 

$query = "SELECT * FROM blog ORDER BY date DESC LIMIT 4";

 

To:

 

$query = "SELECT * FROM blog ORDER BY date DESC LIMIT 4, 99999999";

[FridayRain]

Wow, I'm a dufas. Both of your suggestions (they're the same) actually worked. I only had five test entries in the database. I get two entries to display when I set the limit to 3. Eesh.

 

Thanks, guys.