Uploading XML file into mysql using PHP

[leocmq]

Here is my most current code that is not sending any values to the database but doesnt report any errors.\[code\] foreach($library->time_report as $project){ mysql_query("INSERT INTO instancetable (project_ID, project_status, client_ID, project_start_time, project_end_time, project_total_time, employee_ID, employee_name, date_created, date_modified, created_by, client_name, priority, organization, number_of_required_types) VALUES ('{$project->project_ID}',{$project->project_status}, '{$project->client_ID}', {$project->project_start_time}, '{$project->project_end_time}', '{$project->project_total_time}','{$project->employee_ID}', {$project->employee_name}, {$project->date_created}, {$project->date_modified}, {$project->created_by}, {$project->client_name}, {$project->priority}, {$project->organization}, {$project->number_of_required_types}");\[/code\]}I need to upload an XML file into mysql. It says it is sucessfully uploading, but it just puts a value of 0 in the table. Heres my code:\[code\]<?php echo "starting <br><br>"; //mysql connection$con2 = mysql_connect("localhost","test","test");if (!$con2) { die('Could not connect: ' . mysql_error()); }$selectdb = mysql_select_db("test", $con2);if (!$selectdb) { die('Database not used: ; ' . mysql_error()); }echo "connected to DB<br/><br/>"; //simplexml load xml file $library = simplexml_load_file('http://localhost/instance.xml');echo "xml loaded<br/><br/>";//loop through parsed xmlfeed and print output foreach ($library->message as $message) { printf("project_ID: %s\n", $project_ID->project_ID); }echo "xml parsed<br/><br/>";//insert into databse mysql_query("INSERT INTO instancetable (project_ID)VALUES ('project_ID')")or die(mysql_error());echo "inserted into mysql<br/><br/>";//show updated records printf ("Records inserted: %d\n", mysql_affected_rows()); //close connection mysql_close($con2);echo " <br /> Finished "?>\[/code\]So this is the out put I get:\[code\]starting connected to DBxml loadedxml parsedinserted into mysqlRecords inserted: 1 Finished\[/code\]XML File:\[code\] <?xml version="1.0" encoding="UTF-8" standalone="yes"?><project><time_report> <project_ID>4</project_ID> <project_status>Closed</project_status> <client_ID>6001</client_ID> <time_record> <project_start_time>13:03:19.000</project_start_time> <project_end_time>13:14:26.000</project_end_time> <project_total_time>0.0104166666666667</project_total_time> </time_record> <employee_ID>10001</employee_ID> <employee_name>Mary Beth</employee_name> <date_created>2009-07-02</date_created> <date_modified>2009-11-24</date_modified> <created_by>Mary Beth</created_by> <client_name>BlackRock Funds</client_name> <priority/> <organization/> <number_of_required_types>9999999999</number_of_required_types></time_report>\[/code\]The XML file is shown above, it is much larger so I took just one entry out.