Easy mistake to make.
First of all, you would know what was wrong if you display errors:
As for your problem, I'll show you what functions you're using and maybe you'll notice yourself:
Notice the difference with those last two (hint: MySQL != MSSQL).
mssql_query("SELECT * FROM team");
Oh, and by the way don't bother using MySQL_Close or MSSQL_Close. The connection's automatically closed at the end of the execution anyway. It only needs to be closed if you have ALOT of processing going on after your last MySQL/MSSQL operation.