Im have a problem with this script there is a error here is the script
start ===>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Darkrealm Listing</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style1 {
color: #00FF00;
font-size: x-large;
}
.style2 {
color: #00FF00;
font-size: medium;
}
-->
</style>
</head>
<body bgcolor="#000000" text="#FFFFFF">
<div align="center">
<p class="style1"> </p>
<p class="style2">Search Darkrealms Software Library</p>
<p> </p>
<?php
$strtable = $_REQUEST["category"];
$strsearch = $_REQUEST["search"];
$objConn = mssql_connect("", "", ""); // this line will need changing for MSSQL
$objDb = mssql_select_db("darkrealm");
$sqlString = "Select * FROM ".$strtable." WHERE Name LIKE '%" .$strsearch. "%'";
$objSQL = mssql_query($sqlString); // change this
?>
<TABLE border=2>
<TR><TD><B>Name:</B></TD>
<TD><B>DiscID:</B></TD>
<TD><B>CDs:</B></TD>
<TD><B>Comments:</B></TD>
</TR>
<?
while($objRS= mssql_fetch_array($objSQL))
{ // need to change mysql_fetch_array appropriately
echo "<TR><TD>" . $objRS["Name"];
echo "<TD>" . $objRS["DiscID"];
echo "<TD>" . $objRS["CDs"];
echo "<TD>" . $objRS["Comments"];
}
?>
</TABLE>
</div>
<?php
// change mysql_close appropriately
mssql_close($objConn);
?>
</body>
</html>
end here ===>
the error i get is:
Fatal error: Call to undefined function: mssql_connect() in C:\Inetpub\wwwroot\Darkrealm\dark\1\results.php on line 28
can anyone help me please
HELP PLEASE WITH DATABASE CONNECTION
Moderator: General Moderators
Looks like that extension isn't installed properly, or not at all, on that server.
http://www.php.net/mssql#mssql.installation
http://www.php.net/mssql#mssql.installation