I need a form to update an SQL row, and it needs to echo all the rows with a check box near it as so I may chose one to update. Spoon Feed please.

Never mind I did it my self.

PHP Code:

<?
include("include/opendb.php");
mysql_query("UPDATE `new` SET hide = '' WHERE id = '$_GET[id]'");
echo 'id=bla<br><hr>';

$query = mysql_query("SELECT * FROM `new` WHERE hide='0' ORDER BY id DESC");
while( $row = mysql_fetch_assoc($query) )
{
echo "(<b>{$row['id']}</b>)/{$row['news']}<hr>\n";
}
include("include/closedb.php");
?>

Updated:

PHP Code:

<?
include("include/opendb.php");

$error = array(false, array(), false);
if( isset($_POST['submit']) )
{
    $error['2'] = true;
    if( count($_POST['box']) == 0 )
    {
        $error['0'] = ture;
        $error['1'][] = "Please choose something to update";
    }
    if( $error['0'] == false )
    {
        foreach( $_POST['box'] as $update )
        {
            mysql_query("UPDATE `new` SET hide = '' WHERE id = '$update'");
        }
        $error['1'][] = "Successfully updated news";
    }
}

if( $error['2'] == true )
{
    foreach( $error['1'] as $message )
    {
    echo "$message<br />\n";
    }
}

$content = array();
$query = mysql_query("SELECT * FROM `new` WHERE hide='0' ORDER BY id DESC");
while( $array = mysql_fetch_assoc($query) )
{
    $content[] = "<td>{$array['id']}<input type=\"checkbox\" name=\"box[]\" value=\"{$array['id']}\" /> </td>
                <td> {$array['news']} </td>\n";
}
echo "    <form action=\"hide.php\" method=\"post\">
        <table border=\"1\"><tr><th>ID</th><th>Text</th></tr>\n";
        
foreach( $content as $tds )
{
    echo "    \t<tr>
            \t$tds
        \t</tr>\n";
}
    echo "    </table>";
?>