MS SQL [SOLVED]

[aaronenabs]

Hello


Am finding it difficult to connect to my database hosted on a remote server(university server)
we are using my php and using ms sql... i have looked up a bunch of connect codes for my sql and also ms sql
they both look similiar but i still cant connect to my database using ms sql codes to the university remote server.

secondly i have uploaded most of my files to sftp server for the university i can run most of my html files but the php dont work and i debugged the code and it said pointed out couldnt connect to server again.

Please can anyone tell me which code exactly i need to connect to mssql server as most people using php use mysql not ms sql

block of code am using

Line number On/Off | Expand/Contract | Select all

1. $connect = mssql_connect("", "","");
2.     mssql_select_db("");
3.  
4.     $queryreg = mssql_guery("
5.  
6.     INSERT INTO Customer VALUES('Fname','Sname','Telephone','Address','Postcode','Email','Username','Password')
7.  
8.  
9.     );
10.  
11.     Die('You have been registered'! <a href='index.html'Return to Hompage");   
12.     }

[Hyper]

Please, for the 9035012451569014999999999th time we tell the users, USE THE PHP TAGS

You might want to check your spelling:

Line number On/Off | Expand/Contract | Select all

1. mssql_guery

Its called Query not Guery.

[wide_load]

Please, for the 9035012451569014999999999th time we tell the users, USE THE PHP TAGS

agreed, there is even a reminder when posting new topics !

is it REALLY that hard.

[bowersbros]

also, I would recommend removing your server details off the post. just replace with ***

[wide_load]

also, I would recommend removing your server details off the post. just replace with ***

Fatal error: Call to undefined function mssql_connect() in /home/www/test.php on line 3

damn it ! I should have installed all those extensions I don't need.

[bowersbros]

You tried (again, advertising: use a free host just for fun )

[wide_load]

You tried (again, advertising: use a free host just for fun )

too much effort, I think it would be easier to recompile php

I only wanted to see if the details worked from outside of their network.