halben Posted January 7, 2014 Share Posted January 7, 2014 (edited) 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 Edited January 7, 2014 by halben Quote Link to comment https://forums.phpfreaks.com/topic/285168-sql-statement-help/ Share on other sites More sharing options...
Solution halben Posted January 7, 2014 Author Solution Share Posted January 7, 2014 Figured it out. Thanks for viewing! Quote Link to comment https://forums.phpfreaks.com/topic/285168-sql-statement-help/#findComment-1464269 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.