ID: 24721
Updated by: [EMAIL PROTECTED]
Reported By: adrian at smartcall dot ro
-Status: Open
+Status: Bogus
Bug Type: *Database Functions
Operating System: linux slackware
PHP Version: 4.3.2
New Comment:
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the existing bug instead.
Thank you for your interest in PHP.
see #24720
Previous Comments:
------------------------------------------------------------------------
[2003-07-19 14:50:07] adrian at smartcall dot ro
Description:
------------
I updated my php to php-4.3.2 on apache_1.3.27, I have mysql-3.23.57
and I also use freetds-0.61.
My php ./configure line is
'./configure' '--prefix=/usr/local/misc/php'
'--with-apxs=/usr/local/misc/apache/bin/apxs'
'--with-mysql=/usr/local/misc/mysql'
'--with-sybase-ct=/usr/local/misc/freetds'
All my scripts ( that before worked ) are giveing me the followig error
:
Warning: mysql_result(): supplied argument is not a valid MySQL result
resource
mssql_fetch_row(): supplied argument is not a valid Sybase result
resource
This error apears when no line maches the query !
In the first place I thought that is the freetds driver ... but I saw
that even on mysql i'm geting the same error.
Reproduce code:
---------------
$msdb = mssql_connect("192.168.0.5", "web","webpass");
mssql_select_db("DATABASE",$msdb);
$result = mssql_query("SELECT DEALERS.PASS FROM DEALERS WHERE
DEALERS.DEALER='" . $_POST["DealerName"] . "'", $msdb);
$msrow = mssql_fetch_row($result);
if ( $msrow[0] != $_POST["DealerPass"] )
{ mssql_close($msdb);
include("../include/error_message.html");
exit();
}
Expected result:
----------------
In $msrow[0] I should have the password ( I have the password when
$_POST["DealerName"] matches one of the DEALERS.DEALER from DEALERS )
but if $_POST["DealerName"] can't be found in the table I'm getting
Warning: mysql_result(): supplied argument is not a valid MySQL result
resource
I "echo("Result = ".$result);" and when I have a match I'm getting
"Result = Resource id #7" and when not a match I have "Result = 1". Is
this correct ? Before using php 4.3.2 I didn't faced this problem !
Actual result:
--------------
Warning: mssql_fetch_row(): supplied argument is not a valid Sybase
result resource in /home/www/default/dealer/check_dealer.php on line 7
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=24721&edit=1
