table rows with checkboxes in PHP

Peter B

I am using PHP and after I return a search query from the database I display each result as a table row in HTML. In the administration search results I want to have checkboxes in each row with a select all / none functionality. With this I want to be able to use the selected rows to delete or modify. Similar to Gmail where you can move selected rows to trash. How is this done? How do I insert that into my PHP code. Do I have to display the results in a form?

This is my current code displaying the results. It has no functionality.


$i=0;
while ($i < $num) {

$name=mysql_result($result,$i,"name");
$description=mysql_result($result,$i,"description");
$picturelink=mysql_result($result,$i,"picturelink");
$price=mysql_result($result,$i,"price");
$category=mysql_result($result,$i,"category");
$id=mysql_result($result,$i,"id");
echo "<tr>";
echo "<td> $id<br></td>";
echo "<td> $name<br></td>";
echo "<td> $description<br></td>";
echo "<td> $category<br></td>";
echo "<td> $price<br></td>";
echo "<td> $picturelink<br></td>";
echo "<tr>";

$i++;
}

aidan_walsh

Using this script as a template, get your maximum number by placing the number of rows returned in the loop. Then when you are writing the table, add an extra row with a number as the name.

echo "<input type=checkbox name=C". $1 ." checked>"