Scottish Voting Intention
Scottish Voting Intention for Westminster
Scottish Voting Intentions in Westminster since 2014
rowspan='2' bgcolor='#F7F7F7'> | Survey End Date | CON (%) | LAB (%) | LD (%) | SNP (%) | UKIP (%) | SNP Lead |
|
"; $con = mysql_connect("localhost", "ukpoll_ajwells", "haddock"); mysql_select_db ("ukpoll_pollresults");
$result5 = mysql_query ("SELECT * FROM scotvoteint WHERE Dateno>40310");
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][7] = mysql_result ( $result5, $i, "UKIP"); $datafortable [$i][8] = mysql_result ( $result5, $i, "SNP"); $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][8]>0) {
echo "{$datafortable[$i][8]} | ";
} else {
echo " | ";
}
if ($datafortable[$i][7]>0) {
echo "{$datafortable[$i][7]} | ";
} else {
echo " | ";
}
if ($datafortable[$i][5]>0) {
echo " {$datafortable[$i][5]} |
";
} elseif ($datafortable[$i][5]<0) {
echo " {$datafortable[$i][5]} | ";
} else {
echo " {$datafortable[$i][5]} | "; } } echo "
