removed name field from tc_presidency, updated tc.jpg

[eq/.git] / bin / import_ward_data

diff --git a/bin/import_ward_data b/bin/import_ward_data
index 670383662bcd0a0d9bef1649a5a5c0612dcf0852..6bbfe5657c72c750d25b1dd097ec60d8b06c8a03 100755 (executable)
--- a/bin/import_ward_data
+++ b/bin/import_ward_data
@@ -249,16 +249,16 @@ sub update_tc_district_table
     $sth = $dbh->prepare("select * from tc_district");
     $sth->execute or die "-E- DB error: $DBI::errstr\n";
     while($sqlhashref = $sth->fetchrow_hashref) {
-       $supervisor_name = $sqlhashref->{name};
-       $district = $sqlhashref->{district};
-       $sth2 = $dbh->prepare("select * from tc_individual where name='$supervisor_name'");
-       $sth2->execute or die "-E- DB error: $DBI::errstr\n";
-       $sqlhashref2 = $sth2->fetchrow_hashref;
-       $supervisor_id = $sqlhashref2->{individual};
-       $sth2->finish();
-       $sth2 = $dbh->prepare("update tc_district set supervisor='$supervisor_id' where district='$district'");
-       $sth2->execute or die "-E- DB error: $DBI::errstr\n";
-       $sth2->finish();
+               $supervisor_name = $sqlhashref->{name};
+               $district = $sqlhashref->{district};
+               $sth2 = $dbh->prepare("select * from tc_individual where name='$supervisor_name'");
+               $sth2->execute or die "-E- DB error: $DBI::errstr\n";
+               $sqlhashref2 = $sth2->fetchrow_hashref;
+               $supervisor_id = $sqlhashref2->{individual};
+               $sth2->finish();
+               $sth2 = $dbh->prepare("update tc_district set supervisor='$supervisor_id' where district='$district'");
+               $sth2->execute or die "-E- DB error: $DBI::errstr\n";
+               $sth2->finish();
     }
     $sth->finish();
 }