deleting mysql rows w/ checkboxes...

[jamesp]

okay, in my db i have a table called 'news', from the admin area i want to delete multiple rows from this table using checkboxes.

yeah....i have no idea where to start doing this.

I would do it by making the checkboxes part of a form and having the action of the form as something like 'delete_news.php'

my primary key in this table is the news_id

any help would be great, thanks

[brucec]

James, one way to do this is with array_unshift function.

Everytime you choose a checkbox, add a Javascript onClick event handler to use a PHP array_unshift. I had this same issue and solved it like that.

Or, another way is to have your primary key in a hidden form variable and when they form is submitted, have while go through the pimary keys and inside the while loop, do an IF loop to check if the checkbox is "on" (case sensitive). If the checkbox is on, run an SQL DELETE command, execute the query, and let the loop go to the next item

[mrhappiness]

do something like that

//file: delete_news
$c = mysql_connect('host', 'user', 'pass');
mysql_select_db('database', $c);
if (isset($_POST['del_news']))
{
  $sql = 'DELETE FROM news 
    WHERE news_id 
    IN ('.implode(', ', $_POST['del_news']).')';
  mysql_query($sql, $c);
}
$sql = 'SELECT news_id, news_title FROM news';
$r = mysql_query($sql, $c);
echo '<form method="post" action="'.$_SERVER['PHP_SELF'].'">';
while ($news = mysql_fetch_assoc($r))
  echo '<input type="checkbox" name="del_news[]" 
    value="'.$news['news_id'].'" />'.$news['news_title'].'<br />';
echo '<input type="submit" name="delete" value="Delete" />
</form>';
mysql_close($c);