Need simple links page code created to insert into my website. My website is a search engine, and I have 50,000+ terms that I want to create links for and display on my website, mainly for search engines. MySQL table must have 3 fields for id,URL, and Description. Link list should display 30 records at a time with LINKS to sort list by letter ( A|B|C|D|E|F|G, etc...). List should default to letter A.
When the user clicks on letter B, for example, script will need to lookup in database all records with description field beginning with the letter "B" and return the first 30 in alphabetical order. Then click on NEXT or the page number (Previous|1|2|3|4|5|Next) to skip through list.
Script must be compact (2 files max) and use MySQL on backend. You must provide SQL query to create table and database.
You can use a freeware or shareware script, but it must be modified to meet these requirements and must be written in php. You will need to remove additional features that are not wanted. No admin area needed.
I think this is a $30 project.