Is this still a valid bug in the recent PHP releases?

I will check within the next week or two to verify.

Please try using this CVS snapshot:

  http://snaps.php.net/php4-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-latest.zip

If the problem still occures try upgrading to freetds-0.53 and seeing if that'll solve the problem.

No feedback was provided for this bug for over 2 weeks, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Im am using Windows NT and PHP 4.2.3 and experience the same problems with MS SQL Server 2000: 

i try to do multiple inserts in one query:

<script>
$sql = " INSERT INTO tbl (col1, col2) VALUES( $int1, '$str1');
INSERT INTO tbl (col1, col2) VALUES( $int2, '$str2'); ..."

mssql_query($sql);
</script>

the thing is: one query with more than one insert works, the data is is in the DB. But all others fail. It also works if I do only one insert at the time. 

Even it works, if I put all inserts in one string and do 10000 inserts with one query.
I see a problem here, because the amount of data can grow very large. so there are probably some restrictions to the contents of a string-Variable and the String-Length of a query.

I dont understand, why it is not possible to do a second query after inserting more then one lines... 

chris

I'm trying to recreate the problem, but unfortunately I no longer have the system that I originally had the problem on. I only have available an HP-UX 11.0 system and a Mandrake 8.2 system, and I'm having all kinds of problems building PHP on the HP-UX system. I have just about got it built except for some GD shared library problems. Based upon Chris's last report the problem still exists. Hopefully I will be able to test again by the end of the week.

Please try using this CVS snapshot:

  http://snaps.php.net/php4-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-latest.zip

OK, I know that a lot of things changed in this test, sorry about that - too much time elapsed I guess... I have the following configuration:

Mandrake 8.2 system
Apache 2.0.43 
FreeTDS 0.60
PHP 4.3.0-dev (latest snap)
   PHP API  20020307  
   PHP Extension  20020429  
   Zend Extension  20021010  

'./configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-gd' '--with-zlib' '--with-jpeg' '--with-png' '--with-mssql' '--with-sybase=/usr/local' '--enable-track-vars' '--with-mysql' 

With that setup all apears to work OK now. I can have a failing insert due to a key restraint in the database table and still do updates and other inserts without having to close the connection.

Thanks for the help and your patience with my getting around to testing it.

This bug has been fixed in CVS.

In case this was a PHP problem, snapshots of the sources are packaged
every three hours; this change will be in the next snapshot. You can
grab the snapshot at http://snaps.php.net/.
 
In case this was a documentation problem, the fix will show up soon at
http://www.php.net/manual/.

In case this was a PHP.net website problem, the change will show
up on the PHP.net site and on the mirror sites in short time.
 
Thank you for the report, and for helping us make PHP better.

User reports that the problem has been fixed.

//im coding this code to update multiple records but how come it will only update one record wherein it is the first record...please help...thanks
$temphandle=explode(",",$_POST["oldname"]);
$tempcount=count($temphandle);
//load old names and project handled and delete entries
for($a=0; $a < $tempcount; $a++)
{
 $link=mysql_connect("$host","$user","$password");
mysql_select_db($dbname,$link);
$test="select * from employlist where employlist.fname='".$temphandle[$a]."'";
$display=mysql_query($test,$link);
$row=mysql_num_rows($display);
	if($row<>0){
		$row=mysql_fetch_array($display);
     	$htemp=explode(",",$row["projects"]);
		$hcnttemp=count($htemp);
		 $tempvalue="";
		 $del=0;
		 for($cnt=0;$cnt < $hcnttemp; $cnt++){
		   if($htemp[$cnt]!=$projname){
				 if((abs($hcnttemp-$cnt-$del))<=2){ 
			 		$tempvalue.=$htemp[$cnt];
			 	}else{  $tempvalue.=$htemp[$cnt].","; }
		   }else{  $del++; }	
		 }
		$Query  = "Update  employlist set employlist.projects='". $tempvalue."' where employlist.fname='".$temphandle[$a]."'";
		$save=mysql_query($Query);
		if(!$save) print "did not save";
	}	
$display = null;
$test=null;
$row=null;
mysql_close($link);
}