Re: MS-SQL-query causes error, but works.... Am I blind?

Hi Thomas, Remove the semicolon at the end of your query string. - Frank >Hello! > >Using IIS 4.0 (currently isapi) with PHP4.03PL1, the following >statements cause an PHP-error, but it works: > >*snip* > $check = "UPDATE $table SET ".$query[1]."='".$filename."' > WHERE >".$query[0].";"; > $result = mssql_query($check) or die("Konnte die Datenbankabfrage >nicht durchführen."); // line 86 >*snip* > >the query-string is the following: >UPDATE seastho.Punsch_pic SET Pic3='foto_6_Pic3.jpg' WHERE ID=286; > >and the error-messages: >Warning: Unknown list entry type in request shutdown (853728) in >F:\Inetpub\www\Intranet\misc\punsch\admin\fotos_admin.php on line 86 > >Warning: Unknown list entry type in request shutdown (853728) in >F:\Inetpub\www\Intranet\misc\punsch\admin\fotos_admin.php on line 86 > >Now my question is: Am I blind not to see an fault in the query, which >is that unimportant, that the MS-SQL-Server does what I want, but PHP >recognizes it and destroys my html-output? > >Thanks for any hint, >Thomas > > > >-- >PHP Windows Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >For additional commands, e-mail: php-windows-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >