result listing problem

[Adri]

Hey all,
I heva this problem with the listing of my results. I have a lot of entries in the database and I retreieve them with:

[code]$getentries = mysql_query("SELECT * FROM guestbook ORDER BY id DESC");[/code]

Now, I want to show them with 15 at a time. For this I use:

[code]$start = $offset (=0, 15, 30, 45, depending on which page of the results you are)
$stop = $offset + 15

for ($i=$start; $i<=$stop; $i++) { echo $whatever; }[/code]

The problem is, that when $start=15 and $stop=30 he displays the same results as when $start=0 and $stop=15. He just always takes the first 15 results out of the array :s. How come?!?

[wickning1]

Bad approach, use "SELECT * FROM guestbook ORDER BY id DESC LIMIT $start, 15"