php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #17499 multiple sql statements query doesn't work
Submitted: 2002-05-28 20:36 UTC Modified: 2002-05-29 01:00 UTC
From: dchiod at inwind dot it Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.2.0 OS: win32
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: dchiod at inwind dot it
New email:
PHP Version: OS:

 

 [2002-05-28 20:36 UTC] dchiod at inwind dot it 
try to execute this SQL with a single connection->execute(), but i can't get it work (same SQL is executed correctly in MySQL using other interfaces). 
To be sure it's the same SQL I display it with a echo in php, and copy/paste it in my MySQL frontend (I use Mascon). 
values in SQL are only for example. 

"lock tables attiDeMinimis write; select @progr := numero from attiDeMinimis WHERE id=0; select @progr := @progr + 1; insert attiDeMinimis values (@progr,"test","2002/05/29","DE","CO","",1000,1000,NULL,4); UPDATE attiDeMinimis SET numero = @progr WHERE id=0; unlock tables;" 

multiple statements are ok with mssql.

reply from phplens.com:

This is a php mysql client library issue i suspect. If you are not happy with this, perhaps you can submit a bug report to http://bugs.php.net

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-05-29 01:00 UTC] mfischer@php.net 
You can only issue ONE sql statement at a time.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat Sep 28 23:01:27 2024 UTC