Hello all. I have finally reached the end of my first php project and am ready to move it to the production server. The test server is MS SQL 2003/Apache/PHP whereas the production server is MS SQL 2005/IIS/PHP.
I created a test db and am running the following page to hit it.
<html>
<head>
</head>
<body bgcolor=’yellow’>
<?php
echo “Hello world1<br>”;
$handle = mssql_pconnect (“XXX.XXX.XXX.XXX”, “username”, “password”);
mssql_select_db (“ittest”, $handle);
$recordset = mssql_query (“select * from Employee”, $handle);
while($arr = mssql_fetch_row($recordset))
{
echo “Hello world2<br>”;
echo “$arr[0]<br>”;
}
?>
</body>
</html>
When I hit this page, I get Hello world1, but nothing from the db shows (including Hello world2). Now the server is not my problem, that is the admins job. My question is simple, from the dev standpoint, do I need to make any changes to my code for the move from sql ’03 to ’05?