Sets everything to 0

Hi! I have MySQL database v3.23.49-nt on Windows XP. When I enter the following code into the database the value becomes "0" no matter what I typed in the database (fields marked in [] brackets is data that I wish not to reveal). This is what my screen looks like:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11 to server version: 3.23.49-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use [database];
Database changed
mysql> UPDATE Users SET Verified="1" AND Password="this is the password" WHERE Email="my email address";
Query OK, 0 rows affected (0.01 sec)
Rows matched: 1 Changed: 0 Warnings: 0

mysql> select Email, Verified, Password FROM Users;
+-----------------------+----------+-----------+
| Email | Verified | Password |
+-----------------------+----------+-----------+
| my email addresss | 0 | 0 |
+-----------------------+----------+-----------+
1 row in set (0.01 sec)

mysql>

I have alrady setup the admin account so that I have full permissions.

Can you please help me!!!!!!!!!!!!!!!!!!!!!!!!!
Thanks, AP

From that, it looks like it's definetly permissions. Try adding a new record to the table with an email of "test" and try updating that. Does it work?

I would suggest triple checking your MySQL database and the host and user table also.

thanks mytch, that is my problem. It worked before on my register page, but I guess since I installed PHPTriad (a waste of space program) nothing seems to be working. Thanks.

AP