BPIX
BPIX Voting Intention since 2005
rowspan='2' bgcolor='#F7F7F7'> | Survey End Date | CON (%) | LAB (%) | LDEM (%) | Con Lead |
"; mysql_connect("localhost", "ukpoll_ajwells", "haddock"); mysql_select_db ("ukpoll_pollresults");
$result5 = mysql_query ("SELECT * FROM voteint WHERE Company='BPIX'");
for ( $i=0; $i < mysql_num_rows($result5); $i++ ) { $datafortable [$i][0] = mysql_result ( $result5, $i, "Client");
$datafortable [$i][1] = mysql_result ( $result5, $i, "Date"); $datafortable [$i][2] = mysql_result ( $result5, $i, "Conservative"); $datafortable [$i][3] = mysql_result ( $result5, $i, "Labour"); $datafortable [$i][4] = mysql_result ( $result5, $i, "Libdem"); $datafortable [$i][5] = mysql_result ( $result5, $i, "Lead"); $datafortable [$i][6] = mysql_result ( $result5, $i, "Company"); }
$datafortable = array_reverse($datafortable);
for ( $i=0; $i < count($datafortable); $i++ ) {
echo "| {$datafortable[$i][6]}/{$datafortable[$i][0]} | {$datafortable[$i][1]} | {$datafortable[$i][2]} | {$datafortable[$i][3]} | {$datafortable[$i][4]} | ";
if ($datafortable[$i][5]>0) {
echo " {$datafortable[$i][5]} |
";
} elseif ($datafortable[$i][5]<0) {
echo " {$datafortable[$i][5]} | ";
} else {
echo " {$datafortable[$i][5]} | "; } } echo "
"; ?>