';
$filter = "AND p.letter = 'D'";
$show_party = false;
break;
case "r":
$ballotName = "REPUBLICAN";
$ballotImage = '
';
$filter = "AND p.letter = 'R'";
$show_party = false;
break;
default:
$ballotName = "OPEN PRIMARY";
$ballotImage = '
';
$filter = "";
$show_party = true;
break;
}
mysql_connect($server,$username,$password);
mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT c.id"
. ", concat(c.fname, ' ', c.lname) AS candidate"
. ", p.name AS party"
. ", p.letter AS party_letter"
. ", c.write_in"
. ", c.site_url"
. ", rand() AS rn "
. "FROM `candidates` AS c"
. " ,`parties` AS p "
. "WHERE c.party_id = p.id "
. $filter
. "ORDER BY rn";
$result = mysql_query($query);
$numrows = mysql_numrows($result);
mysql_close();
// captcha code
require_once('recaptchalib.php');
$publickey = "6Lex1gAAAAAAAKcgltFDze_UfIPldQKcFM2Muc27";
?>
2008 ONLINE U.S. PRESIDENTIAL PRIMARYClick button in 1st Choice column
to vote for your first choice candidate. You may also click to indicate
your lower-ranking choices and the candidate you least prefer. (To visit
a candidate's website, click on the candidate's name.) Then complete the
verification section below the candidate grid. Note: Candidates shown in
random order on each ballot for fairness.