PHP with MS SQL SERVER 2000

[zairgotschi]

Hi there.. I have a project in my school, and i'm gonna create a database driven website. I will use PHP 5.2 and MS SQL SERVER 2000. Can someone help me for a step by step tutorial for connecting php to MS SQL SERVER? and for example, my server is on a different computer, how can i link my page to connect to the MS SQL SERVER? Your reply is highly appreciated.. Thanks..

[MadTechie]

For a tutorial No.. this is for HELP with php not a tutorial request section!

 

However!

it should be pretty simple if you alreay know the MySQL setup!

 

<?php
// Connect to MSSQL

$link=mssql_connect("server","user","pass");
$d=mssql_select_db("NorthWind", $db); 

// Do a simple query, select the version of 
// MSSQL and print it.
$query = mssql_query('SELECT * FROM table');
$row = mssql_fetch_array($query);

echo $row[0];

// Clean up
mssql_free_result($version);
?>