Hi all,
I'm new to the forum, as you can see, and fairly new to php. I do have a bit of experience with coding & web-design in other languages however.
What I'm trying to do is use the site I've built with php and mySQL to generate reports (which are monthly newsletters to go out as hardcopies in the snail-mail).
I have the site generating a report page which is fine, but I was hoping to be able to use IE to save the page as "webpage complete" and then open this using MS Word for some extra editing & to add page headers/footers etc..
However, when IE saves the page, it seems to be re-running the script, but without the parameters to generate the queries etc.. So I'm basically getting a blank page with the 'zero results found' message the php script outputs if the SQL query returns nothing.
A further complication is that images included in the report are displayed by giving the 'img src' as a little php script which retrieves the image data from mySQL.
I had thought about using the 'view source' function of IE to get at the html the script generates, but this won't include the images at all.
I've seen links in this forum to tools to generate reports as .pdf (eg http://www.fpdf.org/ ). However, I don't really want to have to handle a pdf, as I'd like to be able to use Word for editing and functions such as mail merge..
Any advice from anyone would be greatly appreciated!
thanks in advance,
mcdruid.
(PS. Sorry this post is really long, but I find it's usually best to give a lot of detail rather than have to clarify things before anyone can help!)
