Hello,

I am needing help with a project that I'm sure can be done but my knowledge with php, MySQL and Linux is limited.

Summary:

I want to pull three pieces of information from two tables in MySQL, join two of those fields, insert them into two specific places in an HTML file that is inside of a ZIP-compressed file. The locations could be designated with text like "INSERTCODEHERE" for a possible Search-and-Replace or php code like <SELECT....>.

I would like to then be able to re-compress this file with a password that is stored in the MySQL db which is associated with this member and which doesn't change. (the 3rd piece of data) The purpose for this is to associated a purchaser with this product that is downloaded from a website. A type of fingerprinting, if you will.

The HTML file could be quite large since we're talking about books here. The zipped file contains about 20 files but the single html file is the large file. Because of this, I don't know if efficiency would call for a server-side text editor and script opening up the file and performing the Search-and-Replace or using <php ?>.

I know this process sounds a bit clunky but we don't have many options. It would be great if these were pdf files where security can included at the creation level, but this format is for special readers for people who are blind. Additionally, it needs to be done 'on the fly' and at the time of purchase.

Any help or suggestions would be greatly appreciated!!!

Rick