Hi, I am trying to access the SQL Server 2005 with PHP. For that I have activated IIS 7 on the windows small business server, for PHP. Now I have the following code for local web hosting :
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta http-equiv="refresh" content="2";url="index.php";>
:: B List ::
$now = time();
$link = mssql_connect("SRVR name", "local host \ user name", "password");
die('ERROR: Could not connect');
mssql_select_db('database name', $link);
$query = mssql_query('SELECT B_No, FROM dbo.B_LIST WHERE B_No = 000011', $link);
$row = mssql_fetch_row ($query);
In this I am just trying to print one row from the database on the webpage
Correct me if I am wrong, as I am coding PHP for the first time with online help.
When I try to access the webpage on the explorer I only get the title and the page if refreshed every 2 seconds , and the time is displayed. Nothing is available from database.