Return query from php- seperate into several pages

Hi all, php beginner say, I have query from a php page that returns several rows, but I don't want to display them all in a single page, but separate them in several pages and then be able to navigate by means of next and previous. Codes snippet would be very helpful. Kind of of page limit

Load data from text file/Excel worksheet

I have an Excel worksheet saved as text file(tab delimited), Load data works fine on my Win2k(MySQL 3.23.38) for bulk loading but on MacOS X , MySQL 3.23.39 the same same file doesn't seem to work right, all I got was malformed data. Using either LOAD DATA or mysqlimport. If there's a bette