PHP 4.0 Bug #9798 Updated: Non-select statements always return false
| From: | sniper@php.net | Date: | Fri, 16 Mar 2001 22:18:39 +0000 |
| Subject: | PHP 4.0 Bug #9798 Updated: Non-select statements always return false | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-49148@lists.php.net to get a copy of this message | ||
ID: 9798
Updated by: sniper
Reported By: jhurshman@rocketmail.com
Old-Status: Duplicate
Status: Closed
Bug Type: MSSQL related
Assigned To:
Comments:
Previous Comments:
---------------------------------------------------------------------------
[2001-03-16 17:03:11] jhurshman@rocketmail.com
Select statement do return true if they succeed. The output of this script is "yesno":
<?php
$db = mssql_connect("host", "user", "password");
$query = 'SELECT * FROM table_name';
$result = mssql_query($query);
echo ($result) ? "yes" : "no";
$query = 'UPDATE table_name SET field_name = "text"';
$result = mssql_query($query);
echo ($result) ? "yes" : "no";
?>
---------------------------------------------------------------------------
[2001-03-16 17:00:24] jhurshman@rocketmail.com
<?php
$db = mssql_connect("host", "user", "password");
$query = 'UPDATE table_name SET field_name = "text"';
$result = mssql_query($query);
echo ($result) ? "yes" : "no";
?>
The output is "no", even though the update has actually occurred. This did not happen with
4.0.3pl1. It began happening when I upgraded to 4.0.4pl1.
I used the "(CGI binary plus server API versions for Apache, AOLserver, ISAPI and NSAPI. MySQL
support built-in, many extensions included, packaged as zip)" Win32 binary.
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=9798&edit=2