phpjoy
-
Posts
1 -
Joined
-
Last visited
Never
phpjoy's Achievements
Newbie (1/5)
0
Reputation
-
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 : ===================================== <head> <meta http-equiv="refresh" content="2";url="index.php";> <title>Trial 1</title> </head> <h1> :: B List :: </h1> <?php $now = time(); echo $now; $link = mssql_connect("SRVR name", "local host \ user name", "password"); if (!$link) { 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); if (!$query) { die('MSSQL error'); } $row = mssql_fetch_row ($query); echo $row; ?> <body> </body> </html> ========================================= 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. Thank you.