[lylesback2]

im working on a news posting script, that only displays the latest 5 posts.

does anyone have an example of a script, that allows you to read articles 5-10, 10-15, 15-20, etc..

Im looking at how to coding page.php, and displaying results from the database. the news articles are seperated by column 'id' 1,2,3,4, etc..

this is an example off the footer of a site i visit:

[Richard]

What I think you'd need to do is set an offset variable, this indicates how far you are in the database (i.e, what page you're on). Something like...

PHP Code:

$sql = mysql_query("SELECT * FROM dbNews ORDER BY newsDate DESC");

$i = 0; $newsPrinted = 0;

while($News = mysql_fetch_array($sql)) {

    if (($_GET['offset'] == $i) && ($newsPrinted < 5) {

        // Echo the news and add a printed

        $newsPrinted++;

    } elseif ($newsPrinted == 5) {

        break;

    }

    $i++;

} 

I think you might be able to do something similar with a MySQL statement...i'm not sure though.

[dennispopel]

Hello,

There is a very nice MySQL feature called LIMIT:

$start = (int)($_GET['start'] / 5)
mysql_query("SELECT * FROM dbNews ORDER BY newsDate DESC LIMIT $start, 5");

Then you can come up with the code that displays links like

$url = "<a href='mypage.php?start=$start'>Page $start</a> "

See if you can create the loop

[Richard]

ooh, i didn't realise you could set a start variable for the LIMIT function...cool

[dennispopel]

Hello,

Yes, MySQL allows this. Anyways you should not iterate thru each row to get to the start row, you should have used the mysql_data_seek function (similar functions help imitate the LIMIT clause for non-supporting DBMS).

[lylesback2]

ahh that was so easy! thanks