Can anybody tell me what I'm doing wrong i want to update my Mysql table with 3 rows. I Selecting checkboxes and i press button then nothing happend with upadate of table. It's saving good id's to array, but update query doesen't work.
$s = mysql_query("SELECT data.id, data.sonda_data, data.type, odp.id, odp.sonda_data, odp.type, odp.wyniki, odp.idp FROM data,odp WHERE data.id=odp.idp");
$i=0;
$tab= array();
while ($row = mysql_fetch_row($s))
{
if ( (isset($_POST['pole'.$row[3]])) && (!isset($_SESSION['security'])) )
{
$id = $_POST['pole'.$row[3]]; // get id from radio boxes
$tab[i]=$id; // saving radio boxes id's to array
$i++; // increment array
// array look like example 8,11,10
if($i==3)
{
while($i>=1)
{
mysql_query("UPDATE odp SET wyniki = (wyniki + 1) WHERE 'id=$tab[$i]'");
$i=$i-1;
}
$_SESSION['security'] = true;
}
}
}