Re: Trouble with updating Mysql table data

[Barry Galbraith]

>PHP is happy to "interpolate:

Ah, but interpolation breaks if you reference an array element with a string index.

e.g. If you had something like this

$sql = "UPDATE library SET title = '$_POST['Title']', author = '$_POST['Author']', status = '$_POST['Status']' WHERE id = $Id ";

Then you have to use concatenation don't you?

$sql = "UPDATE library SET title = '".$_POST['Title']."', author = '".$_POST['Author']."', status = '".$_POST['Status']."' WHERE id = $Id ";

Good luck,
Barry.