[PHP-DEV] PHP 4.0 Bug #7481: When accesing to data with mssql_query php crashes. Seems a pointer error From: danielg <email protected>
Date: 10/26/00

From: danielg <email protected>
Operating system: winnt server 4.0
PHP version: 4.0.3pl1
PHP Bug Type: *General Issues
Bug description: When accesing to data with mssql_query php crashes. Seems a pointer error

function fetchtable()
{
$hostname = "1.100.1.131";
$username = "bdmssql";
$password = "bdmssql";
$dbName = "bdm";

$dbhandle = MSSQL_CONNECT($hostname,$username,$password) or DIE("DATABASE FAILED TO RESPOND.");
mssql_select_db($dbName) or DIE("Table unavailable");

print "<TABLE border=\"1\" width=\"100%\"><TR>";

/* here come some commands to make the query string*/

$salida=MSSQL_QUERY("$str_1 $str_2 $str_3;");
/* the query string looks like:
SELECT t1.ID_PER ,t1.NOMBRE ,t1.APELLIDOS ,t1.NACIONALIDAD ,t1.FECHA_NACIM ,t1.PROFESION ,t1.SEXO ,b7.DESCRIPCION as IDIOMA ,b8.NOMBRE as INSTITUCION
FROM personas t1, IDIOMAS b7, INSTITUCIONES b8
WHERE b7.ID_IDI = t1.REF_IDI AND b8.ID_INS = t1.REF_INS */
$fila=0;
while ($array_sal[$fila] = mssql_fetch_row ($salida))
{
        $fila++;
        print "<TR>";
        print "<TD><INPUT TYPE=\"radio\" NAME=\"registro\" VALUE=\"".$array_sal[$fila-1][0]."\"></TD>";
        for ($p=1;$p<count($array_sal[$fila-1]);$p++)
                { print "<TD>".$array_sal[$fila-1][$p]."</TD>"; }
        print "</TR>";
}
I have only activated php_mssql7.dll

The error is like:
I n the server console an eroor message pops up telling:
---------------------------
php.exe : Application error.
" Intruction "0x7800..." has referenced memory at "0x0065...". I has not been able to write to memory.

Choos Ok to end application.
Choose cancel to debug application.
----------------------------
As you can see It's very likely to be a pointer error , which i think should be corrected.

Thanks anyway

-- 
Edit Bug report at: http://bugs.php.net/?id=7481&edit=1

-- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: php-dev-unsubscribe <email protected> For additional commands, e-mail: php-dev-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>