Salve a tutti, lo so che e' sciocco, ma non riesco ad aggiornare un campo del database, il campo e' un campo di tipo TEXT nel database.

la script e' questa.

Codice PHP:
if (isset($_POST['submit']))    
{        
print_r($_POST);        
$notes = $_POST['$notes'];        
//$notes = mysqli_real_escape_string ($connection->link, $notes);                

// recording data in the database        
$query = "UPDATE invoice SET notes = '$notes'            
WHERE id_invoice='$id'";        

$result = $connection->execute ($query);              

//header("Location: ../show/show_invoice.php");    
} 

il form da dove vengono i dati (che e' nello stesso file) e' questo.

Codice PHP:
<form action="" method="post">        
<div>            
<h1>Modifying Invoice NOTES: <?php echo $id; ?></h1>            
<input type="hidden" name="id" value="<?php echo $id; ?>" />            
Notes :<textarea name="notes" rows="4" cols="50"><?php echo $notes; ?></textarea>
<br/>                        
<input type="submit" name="submit" value="Submit">        
</div>    
</form>