I need to display some data from a mysql database.
There are 2 fields in a mysql db that I need to display in a table: one of them contains fairly long text and needs to be shortened to about 50 characters (displaying a few periods (...) behind it to indicate that it has been cut off). It will also link to a dynamic page using the id that's in the mysql database as well (eg [url removed, login to view])
It needs to be paginated, with each page containing 20 records . The pagination needs to accommodate a large number of pages, so if there are a 100 pages, I don't want all the numbers from 1-100 displayed, but more something like 1-10 and a previous/next link (this is just a suggestion, you can do it anyway you want)