Preserved Topic: MySQL prob. (Page 1 of 1)

Hola, this one is bugging me and I think it's my syntax

I have a guestbook table that has a couple of columns the issues here are the "note" column and the note_date column

When someone enters a note it gets the date.

Now I am pulling the latest 10 from the db like this

"SELECT note FROM guestbook ORDER BY note_date DESC LIMIT 0, 5"

that works great I get the last 5 entries of my guestbook.
Now I'm trying to make it so you can navigate through the guestbook 5 entries at a time. So I have a PHP script that is writing out the links. However on these pages when I use a query like this:

SELECT note FROM guestbook ORDER BY id desc LIMIT 10, 15

I get a result set like this

+-------+----+

The correct syntax for LIMIT is this:

[LIMIT [offset,] rows]

So you should write that part like this:

LIMIT 10, 5

cool deal I figured I had something wrong in the syntax

thanks max


Walking the Earth like Kane