-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmca_list.php
31 lines (27 loc) · 983 Bytes
/
mca_list.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
<?php //require('Includefiles/conn.inc');
//ini_set("display_errors", "on");
require_once('classes/cls.formats.php');
require_once('classes/cls.config.php');
$cons=$_POST['cons'];
$cid=$_POST['cid'];
$dat = '<table class="table table-condensed table-hover">
<thead>
<th>MCA Name</th>
<th>Ward</th>
<th>Political Party</th>
</thead>';
if($cons!='Nominated'){
$query_Contents_4 = $cndb->dbQuery("SELECT * FROM oc_county_profiles WHERE leader_type_id = '4' and constituency = ".q_si($cons)." AND county_id = ".q_si($cid)." ");
} else {
$query_Contents_4 = $cndb->dbQuery("SELECT * FROM oc_county_profiles WHERE leader_type_id = '4' and constituency IS NULL AND county_id = ".q_si($cid)." ");
}
while($row_Contents_4 = $cndb->fetchRow($query_Contents_4))
{
$dat .= '<tr>
<td>'. $row_Contents_4['leader_name'] .'</td>
<td>'. $row_Contents_4['ward'] .'</td>
<td>'. $row_Contents_4['party'] .'</td>
</tr>';
}
$dat .= '</table>';
echo $dat;