Loop

The code below is what I am working with. My radio buttons are generated by mysql I need to make a loop so that I can assign a name to each of the radio buttons. I am assigning a name so that I can assign it to a variable and then use session register to call the variable on another page.

Any help with the loop would be great.

<?
session_start();

if ($_SESSION[valid]!= "yes") {
header("Location: [127.0.0.1...]
exit;
}

$db_name = "voter_ballotDB";

$table_name = "candidate";

$connection = @mysql_connect("localhost", "bobby", "bhappy")
or die(mysql_error());

$db = @mysql_select_db($db_name, $connection) or
die(mysql_error());

$sql = "SELECT cand_id, cand_fname, cand_lname, cand_office, cand_major
FROM $table_name WHERE cand_office = 'President' ORDER BY cand_lname";

$result = @mysql_query($sql, $connection) or die(mysql_error());

while ($row = mysql_fetch_array($result)) {

$cand_id = $row['cand_id'];
$cand_fname = $row['cand_fname'];
$cand_lname = $row['cand_lname'];
$cand_office = $row['cand_office'];
$cand_major = $row['cand_major'];

$menu_block .= "

<input type=\"radio\" name=\"cb1\">$cand_lname, $cand_fname<br>";

}

$button_block .="
<FORM METHOD=POST ACTION=\"vicepresident.php\">
<input type=\"Submit\" value=\"Vote\">
<input type=\"Submit\" value=\"Skip\">

<P><INPUT TYPE=\"submit\" NAME=\"Continue\" VALUE=\"Continue\"></P>
</form>";

<HTML>
<HEAD>
<TITLE>Voting System</TITLE>
</HEAD>
<BODY>
<P><h1><strong>Please Vote For President</strong></h1></P>
<P><stong>Choose From The Following:</strong></P>
<hr>
<? echo "$menu_block";?>
<hr>
<? echo "$button_block";?>
</BODY>
</HTML>

FayeN

jatar_k

lorax

jatar_k

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week