Re: Checkboxes to gather rows to delete

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> Thanks..... The below code returns each ID in an array like so...
> Array ( [0] =>101 [1] => 201 ). Thanks for the help!
> Lewis
>
> $teacherID = $_POST[teacherID];
> $deleteID = $_POST[deleteID];
>
> if(isset($delete_teacher)) {
>       This is where I should loop through checking for the chosen ones to
> delete.....

$query = "DELETE FROM table WHERE teacherID IN (" . implode(',',$deleteID) .
")";
mysql_query($query);

>     }
>
> <form action="" method="POST">
>  print "<input type=checkbox name=\"deleteID[]\"
> value=\"$row[teacherID]\">";
>  print "<input type=submit  name=\"delete_teacher\"  value=\"Delete the
> Checked Teachers\">";

Make sure the column names are correct, but that's it.

---John Holmes...


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux