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:
Warning: MS SQL: Unable to select database: MyDB in
d:\phpsite\INCLUDE\DBManager.php on line 7
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.
any idea's
thanks
Guy