mysql and mssql

[newcastle_unite]

I've got a site using php and mysql, I now need to change the database, so that the site uses sql server instead. Is there any difference as to how one uses the mysql and mssql functions? (for instance mysql_fetch_array and mssql_fetch_array)

[sfullman]

Just started doing that myself. The following main functions are completely analogous to their mssql counterparts

mysql_connect (e.g. use mssql_connect the same way)
mysql_select_db
mysql_query
mysql_num_rows
mysql_fetch_array

However, mysql_error() doesn't have a corresponding mssql_error() function, the error reporting is radically different.

Remember that not all the SQL queries you're so used to with mysql will work in mssql, so you may need ot change your functions as well.

Sam

[newcastle_unite]

You're a star, cheers mate!