Build static multipage table from sql output

I need a php function that will build a static html table from sql output, with X number of results per page. ? The results should be saved to HTML files in output folder. result should be output to html in this format : [login to view URL] ? [login to view URL] [login to view URL] etc Each page should have navigation at bottom <- PREV PAGE | NEXT PAGE -> example: If I am browing on [login to view URL] ? PREV should take me to [login to view URL] and NEXT should take me to [login to view URL] ## Deliverables I need a php function that will build a static html table from mysql output, with X number of results per page. ? The results should be saved to HTML files in output folder. result should be output to html in this format : [login to view URL] ? [login to view URL] [login to view URL] etc Each page should have navigation at bottom <- PREV PAGE | NEXT PAGE -> example: If I am browing on [login to view URL] ? PREV should take me to [login to view URL] and NEXT should take me to [login to view URL] php script workflow: 1. CONNECT TO MYSQL DB 2. SELECT ENTRIES FROM TABLE ? (fields: name, location) 3. OUTPUT SETTINGS TO TABLE table would look like this? ________________________________________________? | name1 | name 2| name 3| name 4| name 5| name 6 ? ? | ? | name7 | name 8| name 9| name10| name11| name12| ________________________________________________| ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? <- PREV PAGE | NEXT PAGE ->