Converting PHP MYSQl &gt; MS SQl

Converting PHP MYSQl > MS SQl

I am going to try and convert some php pages written that connect to a MYsql database, and I know want the to connect to a MS SQL database.

Has anyone got al ink or docs etc that can tell me the different syntax's.

Thanks

Scott

// create connection
$connection = mssql_connect("your_server","your_username","your_password")
or die("Couldn't make connection.");

// select database
$db = mssql_select_db("your_database", $connection)
or die("Couldn't select database.");

// create SQL statement
$sql = "SELECT * from your_table" ;

// execute SQL query and get result
$sql_result = mssql_query($sql,$connection)
or die("Couldn't execute query.");

$numberofresults = mssql_num_rows ($sql_result) ;

while ($row = mssql_fetch_array($sql_result)) {
$field1 = $row["tablefieldname"] ;

echo $field1
}

// free resources and close connection
mssql_free_result($sql_result);
mssql_close($connection);