$db_handle = new DBController();
$sql = "SELECT distinct loksabha_constituency from smla_constituency where zone_number=1 order by loksabha_constituency asc"; // 1 = east / 2 = west / 3 = north / 4 = south // state_id=23 and zonenumber=2";
$row_cons = $db_handle->runSelectQuery($sql);
?>
TN East Zone
Click here
if(!empty($row_cons)) {
foreach($row_cons as $k=>$v) {
echo "";
echo "| ";
echo $row_cons[$k]['loksabha_constituency'];
echo " | ";
}
}
?>
$db_handle = new DBController();
$sql = "SELECT distinct loksabha_constituency from smla_constituency where zone_number=2 order by loksabha_constituency asc"; // 1 = east / 2 = west / 3 = north / 4 = south // state_id=23 and zonenumber=2";
$row_cons = $db_handle->runSelectQuery($sql);
?>
TN West Zone
Click here
if(!empty($row_cons)) {
foreach($row_cons as $k=>$v) {
echo "";
echo "| ";
echo $row_cons[$k]['loksabha_constituency'];
echo " | ";
}
}
?>
$db_handle = new DBController();
$sql = "SELECT distinct loksabha_constituency from smla_constituency where zone_number=3 order by loksabha_constituency asc"; // 1 = east / 2 = west / 3 = north / 4 = south // state_id=23 and zonenumber=2";
$row_cons = $db_handle->runSelectQuery($sql);
?>
TN North Zone
Click here
if(!empty($row_cons)) {
foreach($row_cons as $k=>$v) {
echo "";
echo "| ";
echo $row_cons[$k]['loksabha_constituency'];
echo " | ";
}
}
?>
$db_handle = new DBController();
$sql = "SELECT distinct loksabha_constituency from smla_constituency where zone_number=4 order by loksabha_constituency asc"; // 1 = east / 2 = west / 3 = north / 4 = south // state_id=23 and zonenumber=2";
$row_cons = $db_handle->runSelectQuery($sql);
?>
TN South Zone
Click here
if(!empty($row_cons)) {
foreach($row_cons as $k=>$v) {
echo "";
echo "| ";
echo $row_cons[$k]['loksabha_constituency'];
echo " | ";
}
}
?>