PHP and mssql_query

Anon

I'm having this problem

if i use the function mssql_query() with an Insert or an update then it always returns false, even though when i check in the database i see that the function was successful and the information is there.

I'm using php v4.0.3 and MSSQL 7.0

killswytch

Why don't you show us some of the code you are using to do the queries?

Anon

I'm just using the mssql_query function.

this works:

$iResultId = mssql_query( "SELECT * FROM Users" ,$dbconId );

this works but $iResultId is always = false
$iResultId = mssql_query( "INSERT INTO Users( Id , Name , Password ) VALUES( 10 , "test" , "test" ),$dbconId );

THis means that when ever i test to see if the query was successful then it always goes to the error page even though the insert statement was successful.

And i don't want to use ODBC if i can help it.

Anon

I just started experimenting with PHP and CodeCharge, and I have exactly the same problem.

Did you find a sollution ?
For the moment, I uncomment the error handling.

Luc

Anon

Unfortunantely i have not found a solution to the problem and for the moment have also commented out the error handling. I am waiting to see if a new version of the mssql dll will be released.

Other wise i am now comtemplating changing over to using ODBC as this problem doesn't occur with it.

Anon

Is there a big difference in speed when using odbc ?

Any other disadvantages ?

Thanks,

Luc

Anon

There is slight difference in speed unfortunantely. but that is pretty much the only disadvantage of note.

Otherwise it does have some good advantages like database independance and stuff like that

Anon

Thanks,

Luc

jkelloggs

Hello there!

I experienced the same problem (bad return value from mssql_query), but now I believe that I have found the solution!

One can get an alternative version of PHP for Windows from

http://www.php4win.de/

I downloaded their distribution of PHP405rc1, and the mssql module seems to behave in a different way than the official one from php.net. In this one the mssql_connect returns the value you would expect it to.

Best regards

Frank Sorensen

Anon

Thanks Frank,

I'll do that right now !

Luc

Anon

Thanks 🙂

It works perfectly now