Call to undefined function mssql_connect()

Good day!

I change my database from sql yog to SQL Server 2005 Express so in php the connection is different, so now I am new in SQL Server 2005 Express. i edit my login page and I encountered error:

Fatal error: Call to undefined function mssql_connect() in C:\Inetpub\wwwroot\web_intranet\index.php on line 14

here is my code:


//the user is already logged in, lets redirect them to the other page  

//require_once 'conn.php';    
$server = "PDOMAIN\\MSFW"; 

mssql_connect($server) or die("Cannot connect to server");  
mssql_select_db("$db_name")or die("Cannot select DB");     

        $department = $_POST['department'];     
        $username = $_POST['username'];  

        $sql=mssql_query("SELECT `Department`, `Username` FROM `tbllogin` WHERE `Department` = '{$department}' AND Username = '{$username}'") or die(mssql_min_error_severity());  
        $ct = mssql_num_rows($sql);  
        if($ct == 1) {  
// im guessing this means that the user is valid.  
$_SESSION['loggedin'] = true; // now that the user is valid we change the session value.  
            $row = mssql_fetch_assoc($sql);    
            //$_SESSION['username'] = $row['Username'] ; 
            //$_SESSION['department'] = $row['Department']; 
            $Departments=array('Accounting', 'Engineering', 'Finishing_Goods', 'HRAD', 'MIS', 'Packaging_and_Design', 'Production', 'Purchasing_Logistic', 'QA_and_Technical', 'Supply_Chain'); 
            if (in_array($row['Department'], $Departments)){ 
                    header ('Location:company.php'); 
                    echo "Incorrect Username or Department"; 
                    header ('Location:index.php'); 

thank you

See the link I posted. :wink:


Have you enabled the mssql extension in your php.ini ?

i commented out the mssql extension but still the my webpage did not appear and the error is still there