ami
|
Posted: 01/10/2002, 9:58 AM |
|
i have two db one in www.1serveur.com and the same in www.2serveur.com and i want so that when i update the first the second will be update automaticly in the same time all this with one form.
please give detail about the form(action) and server
thanks
i am waiting for response.
|
|
|
Alex Alexapolsky
|
Posted: 01/11/2002, 1:11 AM |
|
You should place your code into Form/Events/After update.
The code will create a db connection and execute an sql statement.
SQL statement must be build of form field variables accessible via fld prefix.
E.g.
define("DATABASE_NAME","name");
define("DATABASE_USER","aaa");
define("DATABASE_PASSWORD","aaaaaa");
define("DATABASE_HOST","222.333.11.3");
// Database Initialize
$db = new DB_Sql();
$db->Database = DATABASE_NAME;
$db->User = DATABASE_USER;
$db->Password = DATABASE_PASSWORD;
$db->Host = DATABASE_HOST;
$db->query("update some_table set price=" . $fldprice);
|
|
|
|