Jump to content


Photo

Can some help me with Microsoft SQL Server 2005 connection


  • Please log in to reply
1 reply to this topic

#1 Varma69

Varma69
  • Members
  • PipPip
  • Member
  • 15 posts

Posted 27 September 2006 - 05:26 PM

I am creating a web site using Microsoft SQL Server 2005 and using php. before i used MYSQL and php and everything was fine but now i need to know how to change the connect code from the one i use with mysql to work with Microsoft SQL Server 2005.

here is the code i used first can someone show me the modification i need to make.

<?php

$db = mysql_connect("localhost", "root","") or die ("Connection to the db died");
mysql_select_db("lis",$db) or die ("connection to lis db died");

?>

#2 stockton

stockton
  • Members
  • PipPipPip
  • Advanced Member
  • 319 posts
  • LocationMidrand South Africa

Posted 29 September 2006 - 12:27 PM

In my code I just altered the mysql_connect to mssql_connect as well as mysql_select_db to mssql_select_db
Regards,
Alf Stockton   Programmer for rent.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users