mysql php set multi

kv79

hi all

mysql_query("UPDATE users SET username= 'gaga' AND password = 'mile' 
WHERE email = 'da' ");

hi all
This is syntax error but I just wanna show you what I wanted .

I want to set to username and password for where is email=da.

Thanks advance .

djjjozsi

mysql_query("UPDATE users SET username= 'gaga' , password = 'mile' WHERE email = 'da' ");

and here is a whole example, to a valid command:

UPDATE phpcode.collaborate_users SET Address = '2',
Phone = '2' WHERE collaborate_users.id =1 LIMIT 1 ;

You must limit the update, and identify with an ID field...

and use ALTgr - 7 ` signs.

hello,

jjozsi

Piranha

You don't have to limit the update. However, if email can exist only once it is a good idea to limit it, it makes the query a little faster. But if the email can exist more than once you should not limit it, if you do only the first found row will be updated.

You don't have to identify with an ID field. But it is always a good idea to have an identifier.

And no, you don't have to use the backticks `. You only have to use them if you use mysql reserved words as database name / table name / column name.

Oh, by the way. It is not ALTgr - 7 on all keyboards 😉