Build a Website

Build a single page website that had a table with values from a mysql database. The columns are 'url', 'description', 'date url last clicked', 'number of times url clicked' 1)When a url clicks the url it will open the url in another tab and update the 'date last clicked' and 'number of times url clicked column' 2)Table should be able to be sorted using any of the 4 columns above 3)There should be a box at bottom to have table display 10, 25, 100, ALL records 4)jquery can be used for items 2 & 3 5)The url is combination of 3 values. Sample http://www.test.com/category=123&include_abc=true The main table is tbl_categories. This is what the table will be made from. tbl_search_url_part just as two items. The url prefix and postfix *'http://www.test.com/category=' is a static value that is the same for every url. tbl_search_url_part - part_number=1 *'&include_abc=true' is also a static entry that is the same for every url. tbl_search_url_part - part_number=2 *123 will change for each row. It comes from 'node' in tbl_categories So basically you would load two rows from tbl_search_url_part and set two variables. These two variables are to be combined with 'node' from tbl_categories to build a url. Loop over all the values in tbl_categories. Sample database attached