mssql & ph bug???

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Guy
Forum Commoner
Posts: 53
Joined: Sun Jan 12, 2003 3:34 am

mssql & ph bug???

Post by Guy »

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:

Code: Select all

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. win2k, and mssql 2000
any idea's
thanks
Guy
Post Reply