php & mysql newbie help

[thee_saint]

Hi

I need some help with the following. I need to extract some data from mysql database, and display it in colums on a page, with ten or twenty entries per page, and make it user-selectable, so that the user can select how many he wants displayed per page. Similar to a search enige. I need to do this in php, and I'm batteling to get it to display the table with the 10 / 20 / 30 entries, as well as having buttons which will take them forward or backward. If someone can please help me with this, it would be great. It's quite hard learning both mysql and php, if you'v never seen either one of the two, nor have I programmed before, but hey, I learned a LOT in the past two days already, installed mysql, setup databases, etc. Now, I just need to get it on a web page with php.

Thanx

[yelvington]

Click the "Articles" link on the left side of this page and look for an article titled "Building Next/Prev Buttons for Query Results."

And in the MySQL manual, look up the LIMIT clause to the SELECT statement. The key to making this work is to keep track of an offset value.