Bug #15437 Updated: using querries on a database type SELECT * FROM [$tablename] crashes PHP

ID: 15437 Updated by: loginx@linkadmin.org Reported By: loginx@linkadmin.org -Status: Feedback +Status: Open Bug Type: Reproducible crash Operating System: Windows 2000 PHP Version: 4.1.1 New Comment: I have stopped using Windows 2000 for developement, therefore can't reproduce the crash, the code used to produce it in the first time was something really similar to this: $query = "SELECT * FROM [Table1] WHERE User = '$user'"; $connx = mssql_connect($host, $user, $pass) or die("Unable to reach $host"); $result = mssql_query($query, $connx); $depth = mssql_num_rows($result); for ($i = 0; $i < $depth; $i++) { $i_user = mssql_result($result, $i, "User"); echo $i_user; } mssql_close($connx); That's pretty much about it. The problem might have been fixed since... this bug report was posted months ago and produced with php 4.1.1 and not 4.1.0. Previous Comments: ------------------------------------------------------------------------ [2002-06-02 16:37:53] k.schroeder@php.net Please post some source to reproduce this. Regards, Kai ------------------------------------------------------------------------ [2002-03-01 16:51:12] andrew@andrew.co.il I've identical problem with MS SQL Server too. Access violation at 0x00000000 - without any physical address at all. ------------------------------------------------------------------------ [2002-02-07 16:38:35] loginx@linkadmin.org Using the latest PHP version on a Windows 2000 box, I have been able to connect to the MS SQL server 2000 (v7.0) and select the right database, on another script, I am able to write data into the database with no problem with an INSERT statement, however, the SELECT statement doesn't return a value causing the script to time out, therefore, I applied the method of using square braquets around the table name, which causes every single time I execute this script a crash from PHP.exe Xavier Spriet. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=15437&edit=1