[ resolved ]change password problem

[Seitan]

Hey, I'm trying to put together a change password thing, and I keep getting a problem with it. Here is the error.
[quote]Notice: Query: UPDATE `users` SET `password` = SHA('?), `active` = NULL WHERE `user_name` = somename
MySQL Error: Unknown column 'somename' in 'where clause' in /homepages/29/d178597021/htdocs/php/change_password.php on line 50[/quote]

Here is my SQL statement
[code]"UPDATE `users` SET `password` = SHA('$p'), `active` = NULL WHERE `user_name` = {$_SESSION['user_name']}";[/code]

The thing is, that there [b]is [/b]a record with the user_name somename. So I don't get with it. I've tried some variations, like changing it to user_id, but that doesn't work either.

[fert]

change
[code]
"UPDATE `users` SET `password` = SHA('$p'), `active` = NULL WHERE `user_name` = {$_SESSION['user_name']}";
[/code]
to
[code]
"UPDATE `users` SET `password` = SHA('$p'), `active` = NULL WHERE `user_name` = '$_SESSION['user_name']'";
[/code]

[Seitan]

no that didn't work, I just got this instead

[quote]Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /homepages/29/d178597021/htdocs/php/change_password.php on line 49[/quote]

[fert]

then change
[code]
"UPDATE `users` SET `password` = SHA('$p'), `active` = NULL WHERE `user_name` = '$_SESSION['user_name']'";
[/code]
to
[code]
"UPDATE `users` SET `password` = SHA('$p'), `active` = NULL WHERE `user_name` = '{$_SESSION['user_name']}'";
[/code]

[Seitan]

Sweet thanks, that worked.

[Seitan]

by the way, how do I marked this resolved, do I just edit it and add [resolved] or is there a button or link?

[trq]

Just edit the thread.

[Seitan]

cool thanks