<% include "common.php"; if ($ZONECODE == "") { $new = 1; $ZONECODE = 1; } if ($PTYPE == "") { $PTYPE = "NONE"; } $DISTCONST = (int)$DISTCONST; $PARTYCODE = (int)$PARTYCODE ; $DISTCODE = floor($DISTCONST/10); $CONSTCODE = $DISTCONST % 10; if ($SQLSTRING != "") { $TSTRING = "CANDENG LIKE '%". $SQLSTRING . "%'"; } Function convert($DISTRICTCODE, $CONSTITUENCYCODE) { $DISTCONST = $DISTRICTCODE * 10 + $CONSTITUENCYCODE; echo($DISTCONST); return; } $sqlstr1 = "select a1.ZONECODE, "; $sqlstr1 = $sqlstr1 . "a1.ZONE, "; $sqlstr1 = $sqlstr1 . "a1.DISTCODE, "; $sqlstr1 = $sqlstr1 . "a1.DISTRICT, "; $sqlstr1 = $sqlstr1 . "a1.CONSTCODE "; $sqlstr1 = $sqlstr1 . "from elections56_Constituency a1 "; $sqlstr1 = $sqlstr1 . "where a1.ZONECODE = $ZONECODE "; $sqlstr1 = $sqlstr1 . " order by DISTRICT, CONSTCODE"; $sqlstr2 = "select DISTINCT a1.DEVREGIONCODE, "; $sqlstr2 = $sqlstr2 . "a1.DEV_REGION, "; $sqlstr2 = $sqlstr2 . "a1.ZONE, "; $sqlstr2 = $sqlstr2 . "a1.LAST_MP, "; $sqlstr2 = $sqlstr2 . "a1.LAST_MP_PARTY, "; $sqlstr2 = $sqlstr2 . "a1.DISTCODE, "; $sqlstr2 = $sqlstr2 . "a1.DISTRICT, "; $sqlstr2 = $sqlstr2 . "a1.CONSTCODE, "; $sqlstr2 = $sqlstr2 . "a3.CANDENG, "; $sqlstr2 = $sqlstr2 . "a3.AGE, "; $sqlstr2 = $sqlstr2 . "a3.SEX, "; $sqlstr2 = $sqlstr2 . "a3.PARTYCODE, "; $sqlstr2 = $sqlstr2 . "a4.PARTY, "; $sqlstr2 = $sqlstr2 . "a1.Voters, "; $sqlstr2 = $sqlstr2 . "a3.VOTECOUNT, "; $sqlstr2 = $sqlstr2 . "a3.STATUS "; $sqlstr2 = $sqlstr2 . "from elections56_Constituency a1, "; $sqlstr2 = $sqlstr2 . "elections56_Results a3, "; $sqlstr2 = $sqlstr2 . "elections56_Political_party a4 "; $sqlstr2 = $sqlstr2 . "where "; $sqlstr2 = $sqlstr2 . "a1.DISTCODE = $DISTCODE "; $sqlstr2 = $sqlstr2 . "and a1.CONSTCODE = $CONSTCODE "; $sqlstr2 = $sqlstr2 . "and a1.DISTCODE = a3.DISTCODE "; $sqlstr2 = $sqlstr2 . "and a1.CONSTCODE = a3.CONST "; $sqlstr2 = $sqlstr2 . "and a3.PARTYCODE = a4.PARTYCODE "; $sqlstr2 = $sqlstr2 . " order by a3.VOTECOUNT desc, a3.CANDENG "; $sqlstr3 = "select DISTINCT a2.DISTCODE, "; $sqlstr3 = $sqlstr3 . "a2.DISTRICT, "; $sqlstr3 = $sqlstr3 . "a2.CONSTCODE, "; $sqlstr3 = $sqlstr3 . "a3.CANDENG, "; $sqlstr3 = $sqlstr3 . "a3.AGE, "; $sqlstr3 = $sqlstr3 . "a3.SEX, "; $sqlstr3 = $sqlstr3 . "a4.PARTY, "; $sqlstr3 = $sqlstr3 . "a3.VOTECOUNT, "; $sqlstr3 = $sqlstr3 . "a3.STATUS "; $sqlstr3 = $sqlstr3 . "from elections56_Constituency a2, "; $sqlstr3 = $sqlstr3 . "elections56_Results a3, "; $sqlstr3 = $sqlstr3 . "elections56_Political_party a4 "; $sqlstr3 = $sqlstr3 . "where a4.PARTYCODE = $PARTYCODE "; $sqlstr3 = $sqlstr3 . "and a2.DISTCODE = a3.DISTCODE "; $sqlstr3 = $sqlstr3 . "and a2.CONSTCODE = a3.CONST "; $sqlstr3 = $sqlstr3 . "and a3.PARTYCODE = a4.PARTYCODE "; $sqlstr3 = $sqlstr3 . " order by a2.DISTRICT, a2.CONSTCODE"; $sqlstr4 = "select DISTINCT a2.DISTCODE, "; $sqlstr4 = $sqlstr4 . "a2.DISTRICT, "; $sqlstr4 = $sqlstr4 . "a2.CONSTCODE, "; $sqlstr4 = $sqlstr4 . "a3.CANDENG, "; $sqlstr4 = $sqlstr4 . "a3.AGE, "; $sqlstr4 = $sqlstr4 . "a3.SEX, "; $sqlstr4 = $sqlstr4 . "a3.PARTYCODE, "; $sqlstr4 = $sqlstr4 . "a4.PARTY, "; $sqlstr4 = $sqlstr4 . "a3.VOTECOUNT, "; $sqlstr4 = $sqlstr4 . "a3.STATUS "; $sqlstr4 = $sqlstr4 . "from elections56_Constituency a2, "; $sqlstr4 = $sqlstr4 . "elections56_Results a3, "; $sqlstr4 = $sqlstr4 . "elections56_Political_party a4 "; $sqlstr4 = $sqlstr4 . "where " ; $sqlstr4 = $sqlstr4 . "a2.DISTCODE = a3.DISTCODE "; $sqlstr4 = $sqlstr4 . "and a2.CONSTCODE = a3.CONST "; $sqlstr4 = $sqlstr4 . "and a3.PARTYCODE = a4.PARTYCODE "; $sqlstr4 = $sqlstr4 . "and $TSTRING " ; $sqlstr4 = $sqlstr4 . " order by DISTRICT, CONSTCODE"; $sqlstr5 = "select a1.LASTPARTYCODE, "; $sqlstr5 = $sqlstr5 . "a1.LAST_MP, "; $sqlstr5 = $sqlstr5 . "a1.LAST_MP_PARTY, "; $sqlstr5 = $sqlstr5 . "a1.DISTCODE, "; $sqlstr5 = $sqlstr5 . "a1.DISTRICT, "; $sqlstr5 = $sqlstr5 . "a1.CONSTCODE "; $sqlstr5 = $sqlstr5 . "from elections56_Constituency a1 "; $sqlstr5 = $sqlstr5 . " order by DISTRICT, CONSTCODE"; $sqlstr6 = "select PARTYCODE, "; $sqlstr6 = $sqlstr6 . "PARTY, "; $sqlstr6 = $sqlstr6 . "SYMBOL "; $sqlstr6 = $sqlstr6 . "from Political_party "; $sqlstr6 = $sqlstr6 . " order by PARTY"; $sqlstr7 = "select PARTYCODE, PARTY, WINCOUNT, LEADCOUNT from elections56_Results_Sum "; $sqlstr8 = "select DISTCODE, DISTRICT, CONSTCODE, PARTYCODE, "; $sqlstr8 = $sqlstr8 . "PARTY, CANDENG, VOTECOUNT from elections56_Results_Const "; $sqlstr10 = "select PARTYCODE, PARTY, WINCOUNT, VOTES, PERCENTVOTE from elections56_Results_Party "; //open database connection $server = servername(); $db = elections56_db_name(); $user = yomari_user(); $password = yomari_password(); $connect = mysql_connect($server, $user, $password); $dbconnect = mysql_select_db($db, $connect); //first sql query $result1 = mysql_query($sqlstr1, $connect); %>
<% if (($new ==1) && ($SQLSTRING == "") && ($DISTCONST == 0) && ($LASTMP == 0) && ($PARTYCODE == 0) && ($PTYPE == "NONE")) : $result10 = mysql_query($sqlstr10, $connect); $oBL = mysql_fetch_array($result10); %>

 

Summary Results by Party

<%while ($oBL) : %> <%$oBL = mysql_fetch_array($result10); endwhile; %>
Party Seats Total Votes Vote %
"> <%echo($oBL["PARTY"]); %> <%echo($oBL["WINCOUNT"]); %> <%echo((int)$oBL["VOTES"]); %> <%echo($oBL["PERCENTVOTE"]); %>
<%endif; %><% if ($PTYPE == "DECLARED") : $result8 = mysql_query($sqlstr8, $connect); $oCL = mysql_fetch_array($result8); %>

 

Declared Seats

<%while ($oCL) : %> <%$oCL = mysql_fetch_array($result8); endwhile; %>
Constituency Candidate Party Votes
"> <%echo($oCL["DISTRICT"]); %> (<%echo($oCL["CONSTCODE"]); %>) <%echo($oCL["CANDENG"]); %> "> <%echo($oCL["PARTY"]); %> <%echo((int)$oCL["VOTECOUNT"]); %>
<%endif; %><% if (($DISTCODE != 0) && ($CONSTCODE != 0)) : $result2 = mysql_query($sqlstr2, $connect); $oBL = mysql_fetch_array($result2); %> <%$i = 0; while($oBL) : %> <%$i = $i + (int)$oBL["VOTECOUNT"]; %> <%$oBL = mysql_fetch_array($result2); endwhile; %> <%$i = 0; %>
Development Region: <%echo($oBL["DEV_REGION"]); %>
Zone: <%echo($oBL["ZONE"]); %>
District: <%echo($oBL["DISTRICT"]); %>
Constituency No: <%echo($oBL["CONSTCODE"]); %>
Number of Voters: <%echo($oBL["Voters"]); %>
Last Representative: <%echo($oBL["LAST_MP"]); %>
Party: <%echo($oBL["LAST_MP_PARTY"]); %>
Candidate Party Age Gender Votes
><%echo($oBL["CANDENG"]); %> "> <%echo($oBL["PARTY"]); %> <%echo((int)$oBL["AGE"]); %> <%echo($oBL["SEX"]); %> <%echo((int)$oBL["VOTECOUNT"]); %>
Total Votes <%echo($i); %>
<%endif; %><% if ($PARTYCODE != 0) : $result3 = mysql_query($sqlstr3, $connect); $oCL = mysql_fetch_array($result3); %> <%while($oCL) : %> <%$oCL = mysql_fetch_array($result3); endwhile; %>
List of <%echo($oCL["PARTY"]); %> candidates
Declared winners are given in red.
Candidate Constituency Age Gender Votes
><%echo($oCL["CANDENG"]); %> "> <%echo($oCL["DISTRICT"]); %> (<%echo($oCL["CONSTCODE"]); %>) <%echo((int)$oCL["AGE"]); %> <%echo($oCL["SEX"]); %> <%echo((int)$oCL["VOTECOUNT"]); %>
<%endif; %><% if ($SQLSTRING != "") : $result4 = mysql_query($sqlstr4, $connect); $oDL = mysql_fetch_array($result4); %> <%while($oDL) : %> <%$oDL = mysql_fetch_array($result4); endwhile; %>
Your search produced the following result(s):
Candidate Constituency Party Votes
><%echo($oDL["CANDENG"]); %> "> <%echo($oDL["DISTRICT"]); %> (<%echo($oDL["CONSTCODE"]); %>) "> <%echo($oDL["PARTY"]); %> <%echo((int)$oDL["VOTECOUNT"]); %>
<%endif; %><% if ($LASTMP == 1) : $result5 = mysql_query($sqlstr5, $connect); $oEL = mysql_fetch_array($result5); %> <%while($oEL) : %> <%$oEL = mysql_fetch_array($result5); endwhile; %>
List of the immediate past Representatives
Party Representative Constituency
"> <%echo($oEL["LAST_MP_PARTY"]); %> <%echo($oEL["LAST_MP"]); %> "> <%echo($oEL["DISTRICT"]); %> (<%echo($oEL["CONSTCODE"]); %>)
<%endif; %><% if ($LISTSYMB == 1) : $result6 = mysql_query($sqlstr6, $connect); $oFL = mysql_fetch_array($result6); %> <%while($oFL) : %> <%$oFL = mysql_fetch_array($result6); endwhile; %>
List of the all recognized political parties and their symbols
Party Symbol
"> <%echo($oFL["PARTY"]); %> <%echo($oFL["SYMBOL"]); %>
<%endif; %>