Using MS SQL instead of mysql

[Mary_Beth]

How do I use a simple script written for mysql and access MS SQL instead? Do I have to configure PHP differently as well?

<?php

$db = mysql_connect("localhost", "root");
mysql_select_db("retirementDatabase",$db);
$result = mysql_query("SELECT * FROM retirementTable",$db);

$counter=1;
while ($myrow = mysql_fetch_array($result)) {
printf("&investmentField$counter=%s", rawurlencode($myrow["investmentField"]));
$counter++;
}

?>

[jeremuck]

you use mssql functions instead of mysql functions.
There's a possibility that simply changing all your mysqls to mssql will work.

However, it's all very well documented in the PHP manual.

I suggest taking a peak:

http://www.phpbuilder.com/manual/function.mssql-connect.php