Forms

[darkness]

Ive got a form which displays all the rows of a mysql database with a checkbox at the end so users can easily delete the row from the homework, but im not sure how to code it to get it to delete just the row that has been ticked, i know i need some kind of if else statement but i can\'t work out how to detect if a box is ticked or not i know it can be either true or force but cant remember how to code it to detect this, its probably somthing very simple, please help.

[amcgrath]

<input type="checkbox" name="delete[$row_id]">

$delete will be an array with the key being the (presumed) unique id on the database. Loop through and delete....

[darkness]

this is the code ive got so far

<?
$result = mysql_query( "SELECT * FROM hwkset" );
$num_rows = mysql_num_rows( $result );
print "There are currently $num_rows homework(s) set in the table<p>";
while ( $a_row = mysql_fetch_array( $result ) ) {
?>
//Display homework with checkbox at the end
<tr align=center>
<td><?echo $a_row[id]?></td><td width=70><?echo $a_row[year]?></td><td width=100><?echo $a_row[subject]?></td><td width=40><?echo $a_row[Staff]?></td><td width=250><?echo $a_row[hwkset]?></td><td width=90><?echo $a_row[date]?><td><input type="checkbox" name="tick[<? $id?>]"></td>
<?
$num++
?>
</tr>

<?

}
mysql_close( $link );
?>
</table>
<?
$n = $num;
?>
<input type=submit value="Delete Homework">
</form>

and this is wot the action of the form is
elseif($action == "del" && $password == $pass) {

if ( ! $link ) die ( "Couldn't connect to MySQL server" );
mysql_select_db( $db, $link ) or die ( "Couldn't oper $db: ".mysql_error() );

for ($k = 0; $k <= $n; $k++) {
if (trim($tick[$id]) == "") {
?>
The homwork for <?echo $id[$k]?> has been deleted successfully<br>
<?
}
else {
?>
There is no data in <?echo $k?> to be delete<Br>
<?
}
}
exit;
}

ive only but it saying text so i can make sure that if statement works before i do nething else.

but it only displays 1 line and not mutiple lines for each line it displays in the form, and i cant see why. What am i missing

[amcgrath]

Name it this way instead:
<input type="checkbox" name="tick[<? $a_row[id]?>]"></

[darkness]

I must be doing somthing wrong in the second part of the script after i press the button, it still will only display 1 line saying either there is no data to be deleted or there is data to be deleted and i cant work out what to put to find out if the checkbox is ticked