mysql BDB with php problem....
| From: | Koutsogiannopoulos Karolos | Date: | Wed, 18 Jul 2001 07:31:11 +0000 |
| Subject: | mysql BDB with php problem.... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10538@lists.php.net to get a copy of this message | ||
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
_______________________