Thanks for the answer but that's not it. It was my typo. I am really
updating and selecting from the same table.
Perhaps not it either, but strings should be in single quotes, not double
quotes.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
Thanks for the email but that didn't help. I gave the commands again using
only single quotes and I still get no results.
On the old machine we were running MySQL 4.0.15a. Is there any difference
with the password function in these 2 versions?
--
Malka Cymbalista
Webmaster, Weizmann