Hello everyone....
I am trying to use the mysql BDB tables option for safe transaction tables.
I have finally activated BDB support with a 3.23.. mysql Max binary version
using the latest version of php...
I use the following script to test if the BEGIN & COMMIT option works but i
always get the "out of sync message"
The following mysql query is identical to a mysql.com example about
BEGIN/COMMIT.
Can someone offer any help or at least explain me what am i doing wrong???
Has Anyone tried mysql with BDB table and PHP successfully??
Regards.
$handle=mysql_connect("localhost","root","s");
$db=mysql_select_db("safe",$handle);
$query=mysql_query("
BEGIN;
select @A:=SUM(salary) from safe where id = '2';
update safe set salary=@A where id='1';
COMMIT;
",$handle);
_______________________
PGP KEY ID: 0xA86600E9
_______________________
