I have to pass two values to sp first value is nvarchar and second value is Int in SQL server,but i am not getting values, is my code is correct.Please help me out

    $query = mssql_init("courseofferedbyprof", $dbhandle); 
                    mssql_bind($query,"@facultyID",&$facname,SQLVARCHAR,false,false,50);
                    mssql_bind($query,"@count",&$year,SQLINT2,false,false,50);
                    $result=mssql_execute($query);

I suppose a simple question is can you actually connect and run anything using the mssql commands? It's been a while for sure, but last time I did PHP to mssql I had to go through ODBC...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.