si there a way on how to connect "sql server"(not mysql..) with php?

pls help need this badly.

pls add the codes to.. thanks

What kind of sql database are we talking about here? If it is a mssql server then take a look at this:
http://us2.php.net/mssql

PHP 5.1+ also has PDO built in for accessing a database in a more generic way.
http://us3.php.net/pdo

Originally Posted by NullPointer

What kind of sql database are we talking about here? If it is a mssql server then take a look at this:
http://us2.php.net/mssql

PHP 5.1+ also has PDO built in for accessing a database in a more generic way.
http://us3.php.net/pdo

thanks for the help..
but i think the codes are different when connecting using mysql..(?)

one more question:
are the codes in mysql and mssql server different?
and do i need to download the .dll files? for the php.ini..
your a big help to me..

im just a noobe to this..sorry for the questions..

The functions for connecting to a mysql and an mssql database are different, as are the functions for querying those databases. PDO abstracts away from that only so far as connecting and querying a database. That, however may be all that you need considering that SQL is roughly the same no matter what database you are using. It is possible that a query in mssql be identical to a query in mysql, you need only be concerned when a query utilizes a database feature that exists in one but not the other.

PDO, mysql, mssql and a few other database functions are built into php (5.1 or higher for pdo) so you do not have to make any changes to the php.ini or install any dlls to make them work.

Originally Posted by NullPointer

The functions for connecting to a mysql and an mssql PDO, mysql, mssql and a few other database functions are built into php (5.1 or higher for pdo) so you do not have to make any changes to the php.ini or install any dlls to make them work.

wow! you gave me hope.. :-)
uhmmmm.. can i ask for a code in connecting this 2? im sorry if i ask to much.. i think your the only one who can help me.. just the code in connecting the mssql server with php.. thanks. if its ok with you.. thank you so much..

I am having the same problem

Documentation:
http://us2.php.net/manual/en/function.mssql-connect.php

You'll need to have a database setup to begin with and you'll need the server name or address, a valid username and password.

PHP Code:

$server = 'SERVERNAME';
$username = 'user';
$password = 'pass';

mssql_connect($server, $username, $password); 


From there you will have to select the database you're interested in use the mssql commands built into php to work with the database. Read through the documentation for a list of commands and how to use them:

http://us2.php.net/mssql