my $we = "hh";
my $response = XMLin("katrina.xml");
for my $id (keys %{$response->{offer}}) {
$db2->execute($we,$id,$response->{offer}->{$id}->{city},$response->{offer}->{$id
}->{state},$response->{offer}->{$id}->{zip},$response->{offer}->{$id}->{link},$r
esponse->{offer}->{$id}->{slots_available},$response->{offer}->{$id}->{descripti
on});
}
$db->commit();