I have a database table
+--------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| username | varchar(30) | NO | | NULL | |
| for_username | varchar(50) | NO | | NULL | |
| survey | int(2) | NO | | NULL | |
| question | int(2) | NO | | NULL | |
| answer | varchar(50) | NO | | NULL | |
+--------------+-------------+------+-----+---------+----------------+
and this xml:
<?xml version="1.0" encoding="iso-8859-1" ?>
<results>
<username>USERNAME</username>
<for_username>FOR USERNAME</for_username>
<survey>SURVEY ID</survey>
<questions>
<question>
<id>QUESTIONID</id>
<answer>STRING</answer>
</question>
<question>
<id>QUESTIONID</id>
<answer>STRING</answer>
</question>
[...]
</questions>
</results>
It's an xml result of a survey-type application. It can have any number of questions.
I need it parsed and saved in the mysql table. Each question item will generate a line, while username/for_username/survey remain the same.
Will pay $30, I need it done in 2 hours.
Please don't waste my time.