Thanks again here is what I ended up doing.
UPDATE eventum_user SET usr_password = md5('admin') WHERE usr_id = 4;
Chris Grau <[EMAIL PROTECTED]> wrote: On Wed, Feb 28, 2007 at 10:19:59AM -0800,
maverick wrote:
> The UPDATE was wrong but now I have a new problem. It appears the
> command is not doing anything.
>
> mysql> UPDATE eventum_user SET usr_password=MD5('123456') WHERE
> > usr_email='valener (AT) nortghrum (DOT) com';
> Query OK, 0 rows affected (0.00 sec)
> Rows matched: 0 Changed: 0 Warnings: 0
Based on the zero count for rows matched, I'm going to guess that user
e-mail address doesn't exist in the table. Is it really formatted like
that in the table? Does "SELECT * FROM eventum_user WHERE usr_email
LIKE 'valener%'" return anything?
--
Chris Grau
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
mav
CCNA, CCA
---------------------------------
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
