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>
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>