".chr(13); } //Close the connection to the DB mssql_close($db); /////////////////////////////////////////////// /////////////////////////////////////////////// /////////////////////////////////////////////// /////////////////////////////////////////////// /* $server="sotdev4.tech.purdue.edu"; $username="yourID"; $password="yourPass"; // Open DB connection $sqlconnect = mssql_connect($server, $username, $password); //Select the DB you want to use / work with //You will need to change northwind to yourDB name $sqldb = mssql_select_db("northwind",$sqlconnect); //Create the SQL query $sqlquery = "SELECT DISTINCT companyName FROM Customers;"; //execute the SQL query and store the result of the execution into $result $result = mssql_query($sqlquery); //Loop through the results while($row=mssql_fetch_array($result)) { //echo out the value of the column (field) pulled from the database echo $row['companyName']."
\n"; } //Close the connection to the DB mssql_close($sqlconnect); */ /////////////////////////////////////////////// /////////////////////////////////////////////// ?>