Re: Transactions

i have the following two queries i would like to run.


$sql_product = 'SELECT product_id, product_number FROM
t_product ' .
'ORDER BY product_number ASC';

$sql_employee = 'SELECT employee_id, employee_name
FROM t_employee ORDER BY LOWER(employee_name) ASC';

$rs_product = $db->Execute($sql_product);
$rs_employee = $db->Execute($sql_employee);

i read somewhere that a transaction will speed up the
process b/c only one db
connection/hit/request/whatever is made (i may have
said it wrong, but hopefully you get the meaning)
instead of two.

how do i implement the BEGIN and COMMIT in php?  i saw
an example on php.net, but it didn't apply to adodb.
in the example, begin and commit were transmitted to
the db via the the pg_query function.

tia...



__________________________________
Do you Yahoo!?
Make Yahoo! your home page
http://www.yahoo.com/r/hs