Delete a row from a php grid
I have been searching the forum for a few hours and still can't find any simple instructions on how to delete a row from a grid in php. Does anyone have a simple example?
Ideally I would like multiple row selection, and for the user to simply press "delete key", a confirmation box, and then to delete the rows from the grid, delete the rows from mySQL and then refresh the grid.
I am just using the simple:
// grid object name
$name = "obj";
// SQL query
$query = "select number,message,datetime AS Date from tl_numbers WHERE customer = '$user' ";
$result = mysql_query($query);
// add grid to the page
echo activewidgets_grid($name, $result);
Can someone help me with the next few steps?