Hi
You first need the information that your school has given you to access the database...
This will include...
Database User Name
Database Password
Database Server Name
Database Server Port (#) it is listening on
Database Name you have permission to access
Database tables you have permissions to access
One you have this then you can connect using the following PHP functions
// connect
$cs = mssql_connect ( 'server_name:port', 'username', 'password' ) or die ( 'Can not connect to server' );
// select
mssql_select_db ( '[database_name]', $cs ) or die ( 'Can not select database' );
//query
$sql = "SELECT * FROM [TABLENAME]";
$r = mssql_query ( $sql, $cs ) or die ( 'Query Error' );
// loop the result
while ( $row = mssql_fetch_array ( $r ) )
{
/* do stuff */
}
demo