insert thru check boxes

[coolz]

echo "<form method=\"POST\" action=\"form.php\">"; 
while ($myrow = mysql_fetch_array($sql)) { 
        echo "<input type=\"checkbox\" name=\"records_list[]\" value=\"$myrow[id]\">"; 
        echo "<input type=\"hidden\" name=\"idno\" value=\"$myrow[id]\">"; 
        echo "<input type=\"hidden\" name=\"data\" value=\"$myrow[data]\">"; 
} 
echo "<input type=\"submit\" value=\"submit\" name=\"submit\">"; 
echo "</form>" 

if ($submit) { 
    foreach ($_POST['records_list'] as $records_id) { 
    $sql = mysql_query("INSERT INTO TABLE (idno,data) values ('$idno','$sdata')"); 
    } 
} 

It does not insert the appropriate datas.

any ideas how to do it right?

[barand]

You have an array of id's (via checkboxes) but you also need arrays of data otherwise all rows have the same value (last record read).

echo "<input type=\"hidden\" name=\"data[$myrow[id]\" value=\"$myrow[data]\">";

then

if ($submit) {  

    foreach ($_POST['records_list'] as $records_id) {
    $data = $_POST['data'][$records_id];  

    $sql = mysql_query("INSERT INTO TABLE (idno,data) values ('$records_id', '$data')");  

    }  

}

[coolz]

it's empty 🙁 it doesn't insert any data. all fields are left blank. 🙁