Php + Mssql

[obrienkev]

Hi all,

I am having problems getting PHP to work with MSSQL Server.

Using PHP Version 4.3.11

What do I have to change on the php.ini file? I uncommented extension=php_mssql.dll but then all websites using mysql stopped working.

Is the sql code pretty much the same as for mysql? Here's an example:

$query = "select * from admin where username = '$username'
         and password = '$password'";
$result = mssql_query($query) or die(mssql_error());

if (mssql_num_rows($result)>0)
{
    // if they are in the database register the user id
    $HTTP_SESSION_VARS['valid_user'] = $username;
}

Any ideas?

Thanks.

Kevin.

[devinemke]

are you sure you are not confusing MSSQL with MYSQL? i only ask because you say "...but then all websites using mysql stopped working" and your code calls a function mssql_error() which does not exist in PHP (unless you wrote it yourself).

[obrienkev]

I'm switching from mysql to mssql server so just learning the ins and outs of mssql server.
What way should the above code be?

Thanks.