Insert into multiple tables

[Anon]

ls,

I search allmost every message but still I can't find a example code that inserts data into different tables.

Could somebody please help me??

Thanx a lot

Morris

[smarlowe]

Assuming you're using postgresql:

$query0="insert into table1 values('abc',123)";
$query1="insert into table2 values ('xyz',789)";

$conn = pg_connect("connection params");
$res0 = pg_exec($conn,"begin");
$res1 = pg_exec($conn,$query0);
$res2 = pg_exec($conn,$query1);
$res3 = pg_exec($conn,"end");

should work.

[Anon]

thanks it works fine!