delete selected rows in a table

[scorpioy]

I'm building a webpage that display a table which has multiple rows and columns. In the beginning of each row I put a check box that allows the user to select, and a button for deleting the selected rows (constructed just like a normal email's inbox). So far I use JavaScript to detect which rows' check boxes have been checked by clicking the delete button. But I couldn't put database related code in those JavaScript functions or pass values of those selected rows from JavaScript's variable to PHP's variable. So I'm stuck at this point. I want to load the same page and see those selected rows are removed from the table after the delete button is clicked. Could someone give me some ideas for solving this problem?

Thanks a lot.

[tuf-web_co_uk]

yes to post a question about databases here would be a good idea, but to post it in the newbies forum aswell?

the exact same post? come on

you need to remind your self that you only need to post your question once!!

[Drakla]

function delete_links($table)
{
	extract($_REQUEST);
	if( !isset($checkboxes) || !isset($deleteconfirm)) return; //nothing was checked, or delete not confirmed
	$ids=implode(",",$checkboxes);

global $db;

$query="DELETE From $table WHERE id IN ($ids)";
$db->query($query) OR $db->death();

echo "Deleted ".$db->affected_rows()." items<br>";
}

Here the checkboxes are all called the same thing and generated from a database so you'd have

<input type="checkbox" name="checkboxes[]" value="242">
<input type="checkbox" name="checkboxes[]" value="6136">
<input type="checkbox" name="checkboxes[]" value="818">

in the actual generated page. $db->query() is just a wrapper around the actual php mysql commands in case you don't do that