Jump to content

[ resolved ]change password problem


Seitan

Recommended Posts

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.
Link to comment
https://forums.phpfreaks.com/topic/30087-resolved-change-password-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.