halben Posted January 7, 2014 Share Posted January 7, 2014 Hi, I'm working on a reset password for WordPress and I'm stumped on this query. What the query does is when a user requests a password reset, the query makes an update to the user's password and activation key. When I run this query, it's giving me int(0) which is saying there are no rows affected. I ran a var_dump on each POST variables to check if the values are correct and it is, so I'm not sure where the error is coming from this sql statement. $resetQuery = $wpdb -> query($wpdb -> prepare("UPDATE wp_users SET user_pass = %s, user_activation_key = '' WHERE user_login = %s AND user_activation_key = %s" , $hashedPwd , $usernameemail, $key)); If anyone can please assist me, that would be great! -Halben Link to comment https://forums.phpfreaks.com/topic/285168-sql-statement-help/ Share on other sites More sharing options...
halben Posted January 7, 2014 Author Share Posted January 7, 2014 Figured it out. Thanks for viewing! Link to comment https://forums.phpfreaks.com/topic/285168-sql-statement-help/#findComment-1464269 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.