PHP Login Register help

[atlaskid]

Hey

I'm having an issue that I can't find the answer to on google. Im creating a login and register system, only it is by invitation only so the person has to enter their details which get checked with the details on the database before they are allowed to create an account.

I am now writing the bit that inserts the password, heres my code:

Code: Select all

$query= "INSERT INTO members (password) VALUES ('$password') WHERE name='$name' and email='$email'";

$result = mysql_query($query) or die ('Could not execute query');

How do I insert the password into the specific row? I get could not execute query. The idea if that it finds the correct row by matching the name and email... any ideas?

Thanks

[ukgeoff]

You have set-up your sql string in one variable but used a different variable in your execution.

[atlaskid]

Hey, thanks for pointing that out but I changed the for the purpose of this post, it wouldnt work with it the way itis now.

[ukgeoff]

You also have single quotes around what are supposed to be variables thereby turning them into string constants.

[grahame]

Originally Posted by ukgeoff

You also have single quotes around what are supposed to be variables thereby turning them into string constants.

I think the single quotes are fine where you have them. Your main string is double quoted which is fine. However, the INSERT inserts a new row which isn't what you want to do, I don't think - you're looking for an UPDATE to change the password in an existing row or a REPLACE to replace a complete row (but the syntax of that would be different).

[masonbarge]

Use UPDATE.

[atlaskid]

Thanks!!