update query

[slava_php]

Hi,
i'm trying the following form the mysql prompt:

update user_info set user_password = 'caY1EjjVo' where user_id = 'steve' and user_email ='[e-mail]'

it returns:
Query OK, 0 rows affected (0.12 sec)
Rows matched: 1 Changed: 0 Warnings: 0

however, password is changed in the database.

//now to php.

this query is setup in the php script. i check the database and the password has been changed.

how do i check if the password has been set / query successful?
i tried:
if($result)
if(mysql_affected_rows($result))
if(mysql_num_rows($result))

none seem to provide me with the functionality of checking query success.

what am i doing wrong?
thanks
steve

[nemonoman]

mysql_affected_rows($result) should contain an integer if you have updated any rows

try

echo "Mysql updated ".mysql_affected_rows($result);

Or
if (mysql_affected_rows($result) >0)

[slava_php]

nope, it doesn't retrun any value.
please not that at mysql prompt it returns rows affected 0.

thanks
steve

[nemonoman]

you wrote:

update user_info set user_password = 'caY1EjjVo' where user_id = 'steve' and user_email ='[e-mail]'

it returns:
Query OK, 0 rows affected (0.12 sec)
Rows matched: 1 Changed: 0 Warnings: 0

however, password is changed in the database.

Are you simply re-running the same query over and over? Or are changing values each time?

The return says -- I found a row that matched the select criteria

But then it says: I changed nothing

So when you say "password is changed' -- do you mean that you submitted a new value each time?

[slava_php]

yep,
I submit new value each time. and it enters it into the database.
starnge ?

[nemonoman]

Well, I'll try one more question and then admit I'm licked:

you wrote:

i'm trying the following form the mysql prompt:

are you in fact doing that? updating from a mysql console? or using the php mysql_query command

$result=mysql_query"update user_info set user_password = 'caY1EjjVo' where user_id = 'steve' and user_email ='[e-mail]' ";

echo mysql_affected_rows($result);

should produce a page saying "1".

Have you been checking via php a change made via the mysql prompt?

[slava_php]

www.mededint.com/db/forgot_pass.php

there's only 1 user in the table and it sets it correctly only when both are povided.

user: steve
email: [e-mail]

this script will output $query, $result, and mysql_affected_rows($result).
checking database usring mysql console, new pass is set.

i can copy/paste this query to mysql console add ; and it will change the pass as well (of course i'm changing pass string when i do that).

*mistake earlier. when i use mysql console and paste query it outputs:

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

and php scirpt does affect db entry.