mssql_* is unknown function

[antoinep]

mssql_ (e.g. =query) is unknown function.
I installed SQL 7, but PHP4 doesn´t understand
these functions? Why and what can I do please?

[philwong]

this means that php doesnt know that mysql exists! what is your server details, including OS

[antoinep]

I installed Apache, MS SQL7 and PHP. When I make mysql_query evrething works. But I want to use a mssql_query for SQL7. But he doesn´t know functions for SQL7. So I configured php.ini with extension=php_mssql.dll for windows. But now nothing works at all. Do you have please a solution for me?

[The_Chancer]

For the most part, the simple functions of database connectivity etc all you need to do is replace mysql with mssql. There are some areas which are lacking when it comes to MSSQL, but I have it working (MSSLQ 7 and IIS) with no probs (almost anyway).
Look at the PHP.net site for MSSQL in the function list, and it gives you a list of the functions. Always a good starting point (it was for me) and you can build from there.
(Note mssql_rows_affected does NOT work !!! as of PHP4.2.1 anyway)

Try this in PHP.ini

Make sure extensions=php_mssql.dll (no ; in front)

and

[MSSQL]
; Allow or prevent persistent links.
mssql.allow_persistent = On

; Maximum number of persistent links.  -1 means no limit.
mssql.max_persistent = -1

; Maximum number of links (persistent+non persistent).  -1 means no limit.
mssql.max_links = -1

; Minimum error severity to display.
mssql.min_error_severity = 10

; Minimum message severity to display.
mssql.min_message_severity = 10

; Compatability mode with old versions of PHP 3.0.
mssql.compatability_mode = Off

Might help things along a bit.

[_0_05_]

what you have to do is download the other version of php (the one that isnt the install). Download it, and open the extensions directory. Search fo mssql_(something).dll and extract it to the php install directory

this should fix everything