note 88461 modified in function.mssql-bind by danbrown

<?php //IP Address, if instance then IP\Instance $server = 'a.b.c.d'; $link = mssql_connect($server, 'sql_user', 'sql_user_pass'); //Select DB $dbn = 'dbName'; mssql_select_db($dbn); //Define Procedure $lala = 'tstProc'; $proc = mssql_init($lala, $link); //Define Parameters $parm1 = 'one'; $parm2 = 'two'; $parm3 = 'three'; //Load Parameters mssql_bind($proc, '@num', $parm1, SQLCHAR, false, false, 10); mssql_bind($proc, '@naamen', $parm2, SQLCHAR, false, false, 10); mssql_bind($proc, '@desci', $parm3, SQLCHAR, false, false, 10); //Execute Procedure mssql_execute($proc); //Free Memory mssql_free_statement($proc); //...and whenever the wolf did howl, all the sheep had to do was bleat! ?> --was-- //IP Address, if instance then IP\Instance $server = 'a.b.c.d'; $link = mssql_connect($server, 'sql_user', 'sql_user_pass'); //Select DB $dbn = 'dbName'; mssql_select_db($dbn); //Define Procedure $lala = 'tstProc'; $proc = mssql_init($lala, $link); //Define Parameters $parm1 = 'one'; $parm2 = 'two'; $parm3 = 'three'; //Load Parameters mssql_bind($proc, '@num', $parm1, SQLCHAR, false, false, 10); mssql_bind($proc, '@naamen', $parm2, SQLCHAR, false, false, 10); mssql_bind($proc, '@desci', $parm3, SQLCHAR, false, false, 10); //Execute Procedure mssql_execute($proc); //Free Memory mssql_free_statement($proc); //...and whenever the wolf did howl, all the sheep had to do was bleat! http://php.net/manual/en/function.mssql-bind.php