Paginating Query Results

[chrispos]

Hi All,

Good day to you it's raining in England!
I am using php 5 MySQL5 and would like to use a system where I get random results from MySQL database using, title, meta, description, link tables

I would like the results to appear as title, new line, description, new line link, new line.

This would hold a number of hotels in the database but I would like to use a search criteria with the results paginating.

Any help would be great.

PS I have the code so that it returns title description link all on one line but need them to return on table below each other with page 1, 2, 3 etc.

The result should resemble any of the big search engines.

Thanks for your time and I'm sure it will stop raining in England one day just not sure when!

[blckspder]

Here is a simple example of how to setup Pagination:

http://php.about.com/od/phpwithmysql/ss/php_pagination.htm