guestbook prob.- put out mysql database

[floppi]

Hi,

I have a problem with my mysql database. I have made a script to load the guestbook entries into the database.
But when I try to put the entries out into a page several error messages appear.

I use "id" to sort the entries, "name" to save the author of the entrie, "email" and "url" and "message", also "datetime" is save.

Further I have seperated my files into enter.php (to create an entry), insert.php (to save the data into my database) and show.php to put the entries out.

$result = mysql_query("SELECT * FROM gb ORDER BY id DESC");
$gesamt = mysql_num_rows($result);

I want to show a fixed number of entries at one side, if the nuber is higher than the able entries on one side the oldest entries should be able to see on an further page and so on. Always the same number of entries on one page.

Is this possible? If yes how?
thx for help

[flipis]

SQL provides the word LIMIT.

SELECT * FROM gb ORDER BY id ASC LIMIT 0,25

And then, on the next page, you increase the limit variable, and repeat the whole thing

Hope it helps

fLIPIS

[floppi]

I do not know what do you mean....

Can you give me an example or a link to a page where I can view...

thx for help