Problem with MySQL replication

[steftar]

I've got a problem with MySQL replication, when I execute a SQL request with a software for MySQL (ex:MySQL Front), the replication works, but when I execute the same request with my PHP script I find my data in the base but the replication doesn't works.
Have you got an answer to my problem ?

[Oleg Butuzov]

how looks you SQL query ?

[steftar]

I don't think so it's a problem with my query:
at the beginning I made query like this: INSERT INTO table SET field=value but a man said to me it's not a pure SQL query
so now I make my query like this: INSERT INTO table(field1,field2) values(value1,value2) but it changes nothing !

[Oleg Butuzov]

if SQL query work with local data base it must be working with a server data base...

may be problem with MySQL user permition or data base connecting and selecting

[tranquillo]

don't know if it's all that simple but isn't it suposed to be values("value1","value2") and not values(value1,value2) ?

[steftar]

I try many things, and I've got two more informations to add, first the replication works with phpmyadmin so the problem doesn't come from php or perhaps from settings of my DSN, second mysql make me a log file and an update file, the log file contains SQL Query to replicate but not whose made by my php script, and the update file contains all the SQL query.

Perhaps the problem come from settings of my DSN, I use pear classes to connect to my bases, so if someone know pear properties to add to make my replication works reply me.

Thanks for all