convert mysql statements to mssql

[kippy]

Is it difficult to translate basic mysql statements to mssql?

[hyp0r]

No, they both use SQL, it should be faily easy to translate them.

[kippy]

So in a statement like this what would change. This is just an example. The program this is used in just uses simple queries, inserts and updates.

$sql78 = "SELECT * FROM data_one WHERE status !='S' AND type = '$type' AND office = '$office_id' ";
$sql_result78 = mysql_query($sql78); 
while($row78 = mysql_fetch_array($sql_result78)){
$MLOs[] = $row78["MLO"];
}

[kippy]

I guess I just need to know if I can just change the

mysql_fetch_array

mssql_fetch_array

(and of course the other mysql references)

Is it as simple as that.

[chriswheat]

Most of them appear to be the same, the best place to go for this is of course php.net

http://www.php.net/manual/en/function.mssql-fetch-row.php