MS Query doesn't work after upgrade to PHP 5.2

[ideasworking]

Hello,

This morning I upgraded PHP to version 5.2 Now none of my update queries work.

Any idea why the queries stopped working? What should I look at to correct the problem?

Thanks,
Lou

 

[ideasworking]

After a few hours of working through this to determine the problem I have narrowed the problem down to the command that closes the mssql connection. I removed this line

mssql_close;

and now everything works fine. Well maybe I shouldn't say that yet... I'm not sure what the implications will be for not closing the connection.

Any thoughts.

 

[vacunita]

That is apparently correct

http://www.php.net/manual/en/function.mssql-close.php

Look at the one and only user contribution.

However, and this comes form the PHP onlne manual itself:
about the need to use [blue]mssql_close()[/blue]

Note that this isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution.

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.