mssql & ph bug???
Posted: Thu Jan 30, 2003 1:23 am
hello all
when I load a page, I go to the database get my values, and put them into a form.
on submit I call a stored procedure using mssql_query.
it works, and saves the information to the database.
BUT, when reloading the page after the sp, I get an this warning:
the same sql works perfectly fine when loading the page the first time.
I tried to release the result of the query using mssql_free_result
but it didn't work.
im using mssql-connect. win2k, and mssql 2000
any idea's
thanks
Guy
when I load a page, I go to the database get my values, and put them into a form.
on submit I call a stored procedure using mssql_query.
it works, and saves the information to the database.
BUT, when reloading the page after the sp, I get an this warning:
Code: Select all
Warning: MS SQL: Unable to select database: MyDB in
d:\phpsite\INCLUDE\DBManager.php on line 7I tried to release the result of the query using mssql_free_result
but it didn't work.
im using mssql-connect. win2k, and mssql 2000
any idea's
thanks
Guy