Page 1 of 1

HELP PLEASE WITH DATABASE CONNECTION

Posted: Tue Jan 06, 2004 4:30 am
by jpimms
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">&nbsp;</p>
<p class="style2">Search Darkrealms Software Library</p>
<p>&nbsp;</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

Posted: Tue Jan 06, 2004 4:46 am
by m3mn0n
Looks like that extension isn't installed properly, or not at all, on that server.

http://www.php.net/mssql#mssql.installation