In PHP wadhwahitesh windows,ms SQL Server, PHP scripting language, PHP and database
Tags: php, Mssql,wamp
I have successfully connected the MSSQL using PHP, but I got the following warning and system death. Please let me know the problem solved as soon as possible. Thank you
Warning:mssql_query (): supplied argument isn't a valid MS Sql-link resource in c:wampwwwtestsql2005index.php on line 11
Warning:mssql_fetch_array (): supplied argument is isn't a valid MS Sql-result resource in c:wampwwwtestsql2005index.php on Line 12
Line one: $qry = Mssql_query ($sql 1, $dblink);
Line 12:while ($row = Mssql_fetch_array ($qry)) {
$server = ' divine-2953ff11,<port> ';
$server = ' divine-2953ff11sqlexpress ';
$db = ' <database> ';
$dbuser = ' <username> ';
$dbpass = ' <password> ';
$link = Mssql_connect ($server, $dbuser, $dbpass) or Die ("Cannot connect to server");
$dblink = mssql_s elect_db ($db, $link) or Die ("Cannot connect to database");
$sql 1 = "SELECT FirstName from Dbo.persons";
$qry = Mssql_query ($sql 1, $dblink);
while ($row = Mssql_fetch_array ($qry)) {
echo $row ["FirstName"];
}
Mssql_close ($link);