Connecting to SQL Database

7edawg4

I am running into trouble trying to load sign into my database using php. Here is the code I am using, can someone please tell me what I am doing wrong:

<?php

$dbconnection = mssql_connect(localhost,"","")
or die("Could not connect to SQL Server!");
$targetdb = mssql_select_db("CNSData", $dbconnection)
or die("Could not open database \"employees\"");
$sql = "SELECT UserID FROM Student";
$queryresults = mssql_query($sql, $dbconnection)
or die("Could not perform database query");

Here is the Error I am getting

Fatal error: Call to undefined function: mssql_connect() in D:\CNS System\test.php on line 11

bastien

have you read the manual for [man]mssql_connect[/man]?

have you uncommented the mssql functions in the php.ini file?

7edawg4

Hey Bastien,

I emailed the system admin and he is going to enable that for me, thanks you for the help

system

I had the same prob, view this

"
Call to undefined function: mysql_connect()

That's a bug, but you must download and install the following package:
php-mysql-4.2.2-8.0.5.i386.rpm

by the following commands:
- cd /root
- rpm -ivh php-mysql-4.2.2-8.0.5.i386.rpm
"

greetz

[deleted]

Originally posted by 7edawg4
Hey Bastien,

I emailed the system admin and he is going to enable that for me, thanks you for the help

is mssql_connect() no mysql_connect();
You see!!!

I thinking the anwer is PHP installing no mssql support.
like no join without=php-mysql