![[ Video ]](video_front.gif) Hannemann prepares an aggressive campaign against Kobayashi to demand accountability going forward
Angel Pilago's come-from-behind move leaves him in contention with front-runner Billy Kenoi in the mayoral race
The primary results pit a political neophyte against a former mayor to complete the late Mayor Bryan Baptiste's term
Roughly half of the open seats in both chambers are being contested and likely will generate some sparks
Both Democrats and Republicans held rallies to organize their campaigns for the 42-day sprint to Election Day
';
$output .= '
| Mayor—City & County of Honolulu | ';
// MAYOR OF HONOLULU
// (TOP 3 BY HIGHEST VOTE)
$mayor_hnl = "SELECT ID, candidate, votes, percent FROM `p2k8` WHERE `office` = '125' && `candidate` NOT LIKE '%Votes%' ORDER BY votes DESC, candidate LIMIT 0,3";
$mayor_hnl_r = mysql_query($mayor_hnl, $dbcnx);
if (mysql_num_rows($mayor_hnl_r) > 0) {
while($row = mysql_fetch_array($mayor_hnl_r)) {
$candidate = explode(",",$row['candidate']);
$output .= '
| ' . ucfirst(strtolower($candidate[0])) . ' | | ' . number_format($row['votes']) . ' | ' . round($row['percent'],2) . '% | ';
}
} else {
exit();
}
$output .= '
| Mayor—County of Hawaii | ';
// MAYOR OF HAWAII
// (TOP 3 BY HIGHEST VOTE)
$hawaii_mayor = "SELECT ID, candidate, votes, percent, office FROM `p2k8` WHERE `office` = '111' && `candidate` NOT LIKE '%Votes%' ORDER BY votes DESC, candidate LIMIT 0,3";
$hawaii_mayor_r = mysql_query($hawaii_mayor, $dbcnx);
if (mysql_num_rows($hawaii_mayor_r) > 0) {
while($row = mysql_fetch_array($hawaii_mayor_r)) {
$candidate = explode(",",$row['candidate']);
$output .= '
| ' . ucfirst(strtolower($candidate[0])) . ' | | ' . number_format($row['votes']) . ' | ' . round($row['percent'],2) . '% | ';
}
} else {
exit();
}
$output .= '
| Mayor—County of Kauai | ';
// MAYOR OF KAUAI
// (TOP 3 BY HIGHEST VOTE)
$kauai_mayor = "SELECT ID, candidate, votes, percent, office FROM `p2k8` WHERE `office` = '130' && `candidate` NOT LIKE '%Votes%' ORDER BY votes DESC, candidate LIMIT 0,3";
$kauai_mayor_r = mysql_query($kauai_mayor, $dbcnx);
if (mysql_num_rows($kauai_mayor_r) > 0) {
while($row = mysql_fetch_array($kauai_mayor_r)) {
$candidate = explode(",",$row['candidate']);
$output .= '
| ' . ucfirst(strtolower($candidate[0])) . ' | | ' . number_format($row['votes']) . ' | ' . round($row['percent'],2) . '% | ';
}
} else {
exit();
}
/*
$output .= '| LEGISLATURE | ';
$output .= '
| Senate, 18th (D) | ';
// 1: SEN-D18 Senator Kawamoto (D.)
$sen_d18 = "SELECT ID, candidate, votes, percent FROM `p2k6` WHERE `office` = '187' && `candidate` NOT LIKE '%Votes%' ORDER BY votes DESC, candidate LIMIT 0,5";
$sen_d18_r = mysql_query($sen_d18, $dbcnx);
if (mysql_num_rows($sen_d18_r) > 0) {
while($row = mysql_fetch_array($sen_d18_r)) {
$candidate = explode(",",$row['candidate']);
$output .= '
| ' . ucfirst(strtolower($candidate[0])) . ' | | ' . number_format($row['votes']) . ' | ' . round($row['percent'],0) . '% | ';
}
} else {
exit();
}
$output .= '
| Senate, 23rd (D) | ';
// 2: SEN-D23 Melodie Aduja (D.)
$sen_d23 = "SELECT ID, candidate, votes, percent FROM `p2k6` WHERE `office` = '190' && `candidate` NOT LIKE '%Votes%' ORDER BY votes DESC, candidate LIMIT 0,5";
$sen_d23_r = mysql_query($sen_d23, $dbcnx);
if (mysql_num_rows($sen_d23_r) > 0) {
while($row = mysql_fetch_array($sen_d23_r)) {
$candidate = explode(",",$row['candidate']);
$output .= '
| ' . ucfirst(strtolower($candidate[0])) . ' | | ' . number_format($row['votes']) . ' | ' . round($row['percent'],0) . '% | ';
}
} else {
exit();
}
$output .= '
| House, 42nd (D) | ';
// 3: HOU-D42 Tulsi Tamayo (D.)
$sen_d42 = "SELECT ID, candidate, votes, percent FROM `p2k6` WHERE `office` = '231' && `candidate` NOT LIKE '%Votes%' ORDER BY votes DESC, candidate LIMIT 0,5";
$sen_d42_r = mysql_query($sen_d42, $dbcnx);
if (mysql_num_rows($sen_d42_r) > 0) {
while($row = mysql_fetch_array($sen_d42_r)) {
$candidate = explode(",",$row['candidate']);
$output .= '
| ' . ucfirst(strtolower($candidate[0])) . ' | | ' . number_format($row['votes']) . ' | ' . round($row['percent'],0) . '% | ';
}
} else {
exit();
}
*/
$output .= '
As of FINAL printout
Sept 21, 6:30 AM HST
|
More results » |
';
print $output;
?>
|
![[New Starbulletin.com]](http://archives.starbulletin.com/global/images/frontpage/newera_320x120bug.jpg)
![[Primary 2008]](http://archives.starbulletin.com/2008/09/07/promo_election_2008.jpg)
