update query is not executing

[phpsharma]

Hi,

MYSQL version is 4.0.2

When i am trying to update my table with this
Mysql is saying query is OK. But the data is not really updating in table..

UPDATE personal set address_1='myaddress', address_2='address2',
city='Hyderabadnew', state='Andhra Pradesh', zip = '12345', country='US', day_phone='924401271332', eve_phone='', fax_phone='', business='' where uid='3'

can any one see any problemsin query ?

Thanks,
sharma

[Roger_Ramjet]

Query syntax OK but no update usually means nothing matches your WHERE condition.

Now, I guess your uid in an integer, so remove the quotes from around the 3 - it's not a string.
Mysql's dynamic typing should cope with a string-quoted number, but maybe there is a bug in that version. Worth a try anyway.

[phpsharma]

it seems some bug in the verson. i have changed to the latest stable version.

Thanks for your help/idea.