1-way Replication and PHP4

[David Brinks]

I seem to be having a problem when using php with a replicated database and
the replicated database not being updated correctly. I have verified that
replication in general works. When transactions are entered through either
a perl script or through console on the master, the replicated client receives the updates
almost instantly. When a transaction goes through php to the master server, on the other hand,
the master database will be updated but the master does not seem to send the
update to the replicated client.

Mysql version are both 4.0.18.
Mod_php4-4.3.7 is the php code on the web server.

Sample php script...

$conn = mysql_connect($Server, $User, $Pass);
$sql = "INSERT INTO test.database VALUE ('','hello')";
$result = mysql_query($sql,$conn);
$closed = Mysql_close($conn);

I've also tried using a different MySQL account that had all permissions to see if this was a permissions related thing but this didn't make a difference either.

If anyone has any suggestions, I would appreciate it.

Thanks.

David Brinks