On 21 Jul 2017 at 07:33, Edmondo Borasio <edmondobora...@gmail.com> wrote:
> I am updating a record of a SQLite database as follows: > > $db->exec('UPDATE Movies SET name = "new movie" WHERE ID="4"'); > > but instead of using name and ID I want to use some variables, $NewItemName > and $hId. > > Entering the variables as they are won't work. Neither using escape > characters like \"$DbItemName\" and \"$hId\". It would help if you said what language you are using. In PHP, one could do this: $db->exec ('UPDATE Movies SET name = \'' . $DbItemName . '\' WHERE ID=' . $hId); or perhaps: $db->exec ("UPDATE Movies SET name = '$DbItemName' WHERE ID=$hId"); -- Cheers -- Tim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users