Writing a text file from Database data
Posted on 2005-03-23
At the moment I have a 3 very simple tables - 'survey', 'value', and 'variable' that each follow the same structure of having 2 columns - 'Name' and 'Format'
The Variable table appears as below:
What I would like to do is that when any record is added or deleted from this database that a text file with the structure below is created.
<!ELEMENT custom3 EMPTY>
<!ELEMENT custom34 EMPTY>
<!ELEMENT custom345 EMPTY>
<!ENTITY % UDvariable_controls "custom3 | custom34 | custom345 ">
If possible I would also like to be able to have this saved with a '.dtd' extension rather than a '.txt' one. Any help will be greatly appreciated as I have got no-where with this.