radio button link

L

limited

New Member
Hi, another fun project:
I'm printing a list from a table alternating line colors. I'm including
a radio button on each line to link to the URL "target". I've greatly
edited offerings from the net and all is well except that the buttons
do nothing. I don't understand the line:
echo "<input type=\"radio\" name=\"select\" value=\"{$res['target']}\">";
Thanks for any help!

Code:

<!DOCTYPE html><html>
<head>
<title>Email Visits</title>
</head>
<body><center>
<form id="testform" name="testform" action="" method="post"
accept-charset="UTF-8">

PHP Code:
<?php
$host="localhost"; $username="root"; $password="cookie";
$db_name="homedb"; $tbl_name="emailtbl";

/* Connect to server and select databse */
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Define $count
$count = "";

$sql="SELECT * FROM emailtbl ORDER BY target ASC";
$result=mysql_query($sql);

echo '<table border="1" cellspacing="0">';
while($res=mysql_fetch_assoc($result))
{
// Add 1 to the row count
$count=$count + "1";

/* -------------If $count==1 table row color = #FFC600 ----------*/
if($count=="1")
{ echo "<tr bgcolor='#FFC600'>"; }

/* -------------If $count==2 table row color = #ccffff ----------*/
if($count=="2")
{ echo "<tr bgcolor='#ccffff'>"; $count=$count - "2"; }

echo "<td>";
echo "<input type=\"radio\" name=\"select\" value=\"{$res['target']}\">";
echo "</td>";
echo "<td>";echo $res['target'];echo "</td>";
echo "<td>";echo $res['username'];echo "</td>";
echo "<td>";echo $res['password'];echo "</td>";
echo "<td>";echo $res['emailused'];echo "</td>";
echo "<td>";echo $res['lastused'];echo "</td>";
echo "<td>";echo $res['purpose'];echo "</td>";
echo "<td>";echo $res['visits'];echo "</td>";
echo "<td>";echo $res['saved'];echo "</td>";
echo "</tr>";

}
echo '</table>';
mysql_close();
?>
Code:

</table> </form></body></HTML>
 
Cromewell

Cromewell

Administrator
Staff member
limited said:
echo "<input type=\"radio\" name=\"select\" value=\"{$res['target']}\">";
Click to expand...
This is writing out a radio button whose selected value is whatever is in $res['target'] which is coming from your database.

Without your mysql table it's hard to say what exactly will be in it, but it is not trying to make a link.

Why are you doing funky string math with $count?
You can accomplish the same thing with
Code: 
$count = 0;
$count++;
if ($count % 2 == 0) { .... }
else { .... }
 
Troncoso

Troncoso

VIP Member
Man, Cromewell. I won't see you posting for months, but as soon as a programming question pops up, you're all over it.
 
You must log in or register to reply here.
Top