checkbox

[fontener]

I'm looking to use checkboxes to select multiple rows of a query result to delete or edit them (like hotmail).. if you could point me in the right direction as to where I could find this info or get a good start I would appreciate it. Thanks. :o

[djjjozsi]

notice that this is a simple example! Not a full solution.

You need to make a form, and have a while cycle, the $res is a result from your table:

while ( $one_row = mysql_fetch_assoc( $res ) )
{
    /* echo out the other values from the table */

/* create a checkbox with array variable name*/
echo '<td><div align="center"><input type="checkbox" name="del[]" value="' . $one_row["id"] . '"></div></td>';
}

You then close the form...

And in del.php:

if ( isset( $_POST["del"] ) )
{
    $delete_ids = array_map( "intval" , $_POST["del"] );
    $sql = sprintf( "DELETE FROM table WHERE id IN (%s)" , implode( ",", $delete_ids ) );
    mysql_query( $sql ) or die( mysql_error() . $sql );
    echo mysql_affected_rows() . " row(s) were deleted";
    exit();
} 

[fontener]

thanks, I think that'll give me a good start as to what I'm looking for... 🙂