rendered paste body<?php$items = simplexml_load_file('test3.xml');$statements = Array();$tables = Array();foreach($items as $name=>$item){ $sql = Array(); $tbl = Array(); foreach($item as $field=>$value){ $sql[] = " {$field} = '{$value}' "; $tbl[] = " `{$field}` varchar(100) "; } $statements[$name][] = implode(',',$sql); $tables[$name] = "create table $name ".implode(',',$tbl);}foreach($tables as $exec) echo $exec."<br><Br>";foreach($statements as $table=>$inserts) foreach($inserts as $insert) echo "insert into {$table} set {$insert}<br><Br>"; ?>