Hi, I'm doing a college project which involves automatically generating student transcripts from a MySQL database. I want to be able to create a system whereby the user enters the student no, and a Word document is automatically generated which displays the student's results in a a letter format. I am able to create the Word document no problem; it's the formatting that I'm having trouble with. If, say, the student is in fourth year, then the Word document must display four sets of results, like the document I attached.
So my question is this: What's the best way to generate a Word document like the attached document where four year's results will neatly fit on one page? Should I do a HTML template within PHP or have some mechanism to paste the data into a Word template? Or is there a better way to do it?
I'd really appreciate your suggestions!