Offset

[stezz]

Hey!

Im trying to make "Next" and "Previous" buttons for my website and Im having trouble with using the offset in my query.

the query...

$result = mysql_query("SELECT * FROM slackernet_news LIMIT offset = '$start',10;");

$start is 0 to begin with and will increase by 10 each time you hit net or decrease by 10 each time you hit previous. I want to limit the number of results per page to 10.

Could someone please tell me what's wrong with my query?

Thanks!

Stezz.

[ahundiak]

From the manual:
SELECT * FROM table LIMIT 5,10;
No quotes around the numbers.