PHP Access violation

[Anon]

I am running Apache 1.3.6 on NT4.0 (sp4) with php4 v4.0.2, and MS Sql Server 7.0. If I try to use any PHP function (explode, substring, etc.) while looping through a result set (I am building a dynamic web page), I will get an access violation. It is repeatable on command.

Sample code:

$connect=mssql_connect("localhost","user","db_nm");
$result=mssql_query("select col1,col2 from table");

while($row=mssql_fetch_array($result))
{
$first_col=$row['col1'];
$second_col=$row['col2'];
explode(" ",$first_col);
}
mssql_free_result($result)l
mssql_close($connect);

[Anon]

I have run into this problem before. My quick fix was to use an indexed array (mssql_fetch_row) rather than an associative array. It worked for me. Try it ...