XML Integration between an PHP Admin Panel and a Flash Gallery

DETAILS: 1. I'm using a PHP Admin Panel based on PHP Web Framework. 2. Admin user can save Product data into a MySQL Database >> Products table: 3. Every time a user adds or edit data from a form, I want to be created a UTF-8 XML File which contains some of the data. I want a specific XML Structure. ## Deliverables 1. UTF-8 with BOM extracted XML 2. XMLParser 3. All other source files. SCOPE: XML Integration between an PHP Admin Panel and a Flash Gallery DETAILS: 1. I'm using a PHP Admin Panel based on PHP Web Framework. 2. Admin user can save Product data into a MySQL Database >> Products table: 3. Every time a user adds or edit data from a form, I want to be created a UTF-8 XML File which contains some of the data. I want a specific XML Structure. a. fopen a standard XML file ([login to view URL]): b. Construct the rest of the XML using the following SQL query : HOW I IMPLEMENTED THIS UP TO NOW: 1. I'm using a products form (add/list/details/delete) with PHP Web Framework (see from example SPECS\admin\forms\admin\products\[login to view URL]) 2. Every time a user adds or edit products redirect tag is the following phtml page: [login to view URL] (see SPECS\admin\[login to view URL]) 3. In [login to view URL] there are 6 Queries/recordsets, which costructs 8 xml files based on MySQL Data 4. [login to view URL] creates every XML file (fopen [login to view URL] >> add tags and attributes based on SQL Query >> saves XML File) MY SOLUTION WORKS BUT I HAVE 2 BASIC PROBLEMS: ------------------------------------------------- 1. My [login to view URL] creates an NON UTF-8 XML !!! I WANT ALL XMLS TO BE UTF-8 ENCODED (AND NOT ANSI), JUST LIKE TEXTPAD (for example) SAVES THEM 2. My [login to view URL] creates WRONG XML structure. I WANT TO BE CREATED THE FOLLOWING STRUCTURE (GROUPED TAGS BASED ON category name): My [login to view URL] creates the following structure: ## Platform MySQL 3.23.49 and PHP 4.3.11.