I am using the following code for updating the table in mysql database. It ain't working

Question

$query = "update admin set username = $username and password = $password where id = 1;

Any alternative to use this code with php?

admin - table name, username and password are the field name and $username and $password are values to be assigned in each field. — Programmer Sishir, Mar 20 '16 at 15:31

score 1 · Answer 1 · answered Mar 20 '16 at 15:31

1

You need to use quotes around the variables.

Try this:

$query = "UPDATE admin SET username = '".$username."', password = '".$password."' WHERE id = 1";

Hope this helps.

Peace! xD

answered Mar 20 '16 at 15:31

Indrasis Datta

1 Answers1