Populus

"; mysql_connect("localhost", "ukpoll_ajwells", "haddock"); mysql_select_db ("ukpoll_pollresults");

$result5 = mysql_query ("SELECT * FROM voteint WHERE Company='Populus'");

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, "UKIP"); $datafortable [$i][7] = mysql_result ( $result5, $i, "Green"); }

$datafortable = array_reverse($datafortable);

for ( $i=0; $i < count($datafortable); $i++ ) {















echo "";















if ($datafortable[$i][6]>0) {



















echo "";















} else {



















echo "";































}















if ($datafortable[$i][7]>0) {



















echo "";















} else {



















echo "";































}















if ($datafortable[$i][5]>0) {



















echo "";















} elseif ($datafortable[$i][5]<0) {





















echo "";















} else {





















echo ""; } } echo "

rowspan='2' bgcolor='#F7F7F7'>	Survey End Date	CON (%)	LAB (%)	LDEM (%)	UKIP (%)	GRN (%)	Con Lead
Populus/{$datafortable[$i][0]}	{$datafortable[$i][1]}	{$datafortable[$i][2]}	{$datafortable[$i][3]}	{$datafortable[$i][4]}	{$datafortable[$i][6]}		{$datafortable[$i][7]}		{$datafortable[$i][5]}
{$datafortable[$i][5]}
{$datafortable[$i][5]}