The Bluegrass Blog » The Bluegrass Blog Awards Poll 2009 Results: News at the speed of bluegrass!

Entertainer of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM entertainer GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM entertainer ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Vocal Group of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM voxgroup GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM voxgroup ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Instrumental Group of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM instgroup GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM instgroup ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Song of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM soty GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM soty ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Album of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM aoty GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM aoty ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Gospel Recorded Performance of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM gospel GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM gospel ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Instrumental Album of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM instalbum GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM instalbum ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Recorded Event of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM recordedevent GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM recordedevent ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Emerging Artist of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM emerging GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM emerging ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Male Vocalist of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM mvox GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM mvox ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Female Vocalist of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM fvox GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM fvox ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Banjo Player of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM banjo GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM banjo ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Bass Player of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM bass GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM bass ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Fiddle Player of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM fiddle GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM fiddle ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Dobro Player of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM dobro GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM dobro ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Guitar Player of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM guitar GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM guitar ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”

Mandolin Player of the Year

“;

$query = “SELECT groupid, SUM(vote) AS total FROM mando GROUP BY groupid”;
$result = mysql_query($query);
$row = mysql_fetch_object($result);
$total = $row->total;

// if votes have been cast
if ($total > 0) {
// reset variables
unset($query);
unset($result);
unset($row);

$query = “SELECT display, vote, color FROM mando ORDER BY vote DESC”;
$result = mysql_query($query);

echo ‘

‘;

// iterate through data
// print absolute and percentage totals
while($row = mysql_fetch_object($result)) {
echo ‘

‘;
echo ‘

‘;
// echo ‘

‘;
echo ‘

‘;

}

echo ‘

‘.$row->display.’

‘.$row->vote.’ votes

color.’.gif\’ height=\’10\’ width=’.round(($row->vote/$total) * 100, 2).’ border=\’0\’ alt=\”.round(($row->vote/$total) * 100, 0).’%\’ title=\”.round(($row->vote/$total) * 100, 0).’%\’>';
echo ‘

‘.round(($row->vote/$total) * 100, 0).’%

‘;

}

echo ”