$select = "SELECT id FROM carrello ";
$results = mysql_query($select);
$i = 0;
while($query = mysql_fetch_assoc($results)){
$array[] = $query;
}

print_r($array);


foreach ($array as $value) {
mysql_query("UPDATE carrello SET stato='confermato' WHERE id='$value'") or die();
}

continua a non modificarmi nulla.. UFF!!