Paging Php/mysql?

[angst]

hello,
I'm trying to figure out a simple way to show 12 data base entries on one page (which i have done alreday), and then be able to move to the next 12 or so on, with a forward link, going back would be simple just using javascript history, or php referre.

but i'm can't figure out how to move forward.

this is my select statement:

$result = mysql_query("SELECT * FROM picdata where PicSection= '$view' LIMIT 12 ") or exit(mysql_error());

can this be done just using the select statement?
and if so how?

thanks in advance for your time!
-Ken

[Angelis]

You need to "paginate" the results.

More help can be found on this page: [webmasterworld.com...]