Updating Remote MySQL Table

[Jove]

Hi Folks,

 

I've got a very strange MySQL problem: I'm trying to update a table lying on a remote server. Everything works fine, except one single query, something like:

UPDATE db.table SET field='1' WHERE id='2';

There's no MySQL-Error, mysql_query() returns true and mysql_affected_rows() returns 1, but theres no change in the table I'm trying to update. If I run the query in phpMyAdmin (which also lies on the server where the php-script is located) it works and all changes are made. Since I use the same user and password I've got no idea what's wrong with the script or the server configuration.

Does anyone have an idea how to solve this problem?

 

Both machines are Linux xen-vservers.

[cooldude832]

and u have a connection to that db/server and rights to mod it with the logged in user?

[Jove]

yes, there are also other queries (SELECT, INSERT INTO and UPDATE) which are successfully executed via this connection