Project Detail

Description

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.


Additional information submitted:

08/18/2008 at 1:44 EDT:
How can you guys expect to get work if you don't even read the project description? I said 2 hours, and $30, and i don't need anything but these damn 50 lines of code.

@GAF: you really need to set up some kind of flagging system, so that these spammers and fakers will get flagged and banned.