RE: We have just moved to a new web server where we are runningmysql version: 5.0.45

2008-04-09 Thread Edward Kay
We have just moved to a new web server where we are running mysql version: 5.0.45 On the old machine, when we gave the following command: update table1 set passwd = password('xx') where user_name=xx; Here you're updating 'table1'... and then gave the following command, SELECT user_name

RE: We have just moved to a new web server where we are runningmysql version: 5.0.45

2008-04-09 Thread Malka Cymbalista
Thanks for the answer but that's not it. It was my typo. I am really updating and selecting from the same table. -- Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 On 4/9/2008 at 1:54 PM, in message [EMAIL PROTECTED], Edward Kay [EMAIL PROTECTED]