mysql, php, checkbox
| From: | Adrian Partenie | Date: | Thu, 28 Nov 2002 15:27:34 +0000 |
| Subject: | mysql, php, checkbox | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-126415@lists.php.net to get a copy of this message | ||
Hello,
I'm displaying the content of a mysql table with autoincrement index. I want to be able to
select the each row from the table using the check boxes. In order to do that, i want to assign to
each checkbox the name=index of selected row.
I assign to the checkboxes the value of selected id, but I can't retreiveit later for further
processing. My code looks like this
$query = "SELECT * FROM reclamatie";
$result = mysql_query($query) or die("Query failed");
/* Printing results in HTML */
echo "<table border=1>";
echo
"<tr><td></td><td>ID</td><td>Subject</td><td>Open</td><td>Close</td></tr>";
while($row = MySQL_fetch_array($result)) {
echo "<tr><td><form><input type=\"checkbox\"
method=\"post\"
name=\"{$row['id']}\"></form></td>"; // ??????????
echo "<td><a href=\"lowerframe.php?id={$row['id']}\"
target=\"lowerframe\">{$row['id']}</a></td>"; //for other
purposes, it works fine
echo "<td>{$row['subject']}</td>";
echo "<td>{$row['open']}</td>";
echo "<td>{$row['close']}</td></tr>";
}
echo "</table>";
Any sugestions if i want to use forms, something like
<form method="post" action="selectare.php?id=$row['id']>
<input type="Submit" value="Trimite" >
</form>
Thanks, Adrian