ok so im trying to connect to a data base in mssql threw my website hosted with x10hosting but i get a error on line 8 or a line with this in it mssql_connect
heres the page with the error
http://www.kramansro.net/test.php
heres my test code
Code:<?php $myServer = "76.31.255.120"; $myUser = "sa"; $myPass = "1234"; $myDB = "silk"; //connection to the database $dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer"); //select a database to work with $selected = mssql_select_db($myDB, $dbhandle) or die("Couldn't open database $myDB"); //declare the SQL statement that will query the database $query = "SELECT id, name, year "; $query .= "FROM cars "; $query .= "WHERE name='BMW'"; //execute the SQL query and return records $result = mssql_query($query); $numRows = mssql_num_rows($result); echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>"; //display the results while($row = mssql_fetch_array($result)) { echo "<li>" . $row["id"] . $row["name"] . $row["year"] . "</li>"; } //close the connection mssql_close($dbhandle); ?>


LinkBack URL
About LinkBacks
Reply With Quote

