I have a bit of a strange one and it's been a while since I've done very much with MySQL.
I'm working on a script that's using the PHP Login Project at it's base. My server is running PHP 5.3.29 and MySQL 5.5.40.
When I run the UPDATE query I get a failure and when I run the SELECT query I get a success. I've tried to simplify the following queries as much as possible.
The UPDATE which fails is this:
$query_update_user = $this->db_connection->prepare('UPDATE users SET user_active = 1 WHERE user_id = 2');
The SELECT which succeeds is this:
$query_update_user = $this->db_connection->prepare('SELECT user_active FROM users WHERE user_id = 2');
Both are executed with this:
$query_update_user->execute();
Any tips are much appreciated.
Thanks
I'm working on a script that's using the PHP Login Project at it's base. My server is running PHP 5.3.29 and MySQL 5.5.40.
When I run the UPDATE query I get a failure and when I run the SELECT query I get a success. I've tried to simplify the following queries as much as possible.
The UPDATE which fails is this:
$query_update_user = $this->db_connection->prepare('UPDATE users SET user_active = 1 WHERE user_id = 2');
The SELECT which succeeds is this:
$query_update_user = $this->db_connection->prepare('SELECT user_active FROM users WHERE user_id = 2');
Both are executed with this:
$query_update_user->execute();
Any tips are much appreciated.
Thanks