Search the Community

Hi Professionals I have the following php file which works and returns data from the database <?php $server='d3licsql02'; $connectinfo=array("Database"=>"TestData", "UID" => "sa", "PWD" => "secret"); //connect to DB $conn=sqlsrv_connect($server,$connectinfo); if( $conn === false ) { die( print_r( sqlsrv_errors(), true)); } $sql = "SELECT distinct software_manufacturer FROM softusecomp"; $stmt = sqlsrv_query( $conn, $sql); if( $stmt === false) { die( print_r( sqlsrv_errors(), true) ); } while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) { echo "<option value="; echo "'".$row['software_manufacturer']."'"; echo ">"; echo $row['software_manufacturer']; echo "</option>"; } sqlsrv_free_stmt( $stmt); ?> </select> <input type="submit" value="Search"> </br></br> </form> </body></html> I have changed this to two seperate files below which do not work <?php include('ConnectDB'); $sql = "SELECT distinct software_manufacturer FROM softusecomp"; $stmt = sqlsrv_query( $conn, $sql); if( $stmt === false) { die( print_r( sqlsrv_errors(), true) ); } while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC) ) { echo "<option value="; echo "'".$row['software_manufacturer']."'"; echo ">"; echo $row['software_manufacturer']; echo "</option>"; } sqlsrv_free_stmt( $stmt); ?> </select> <input type="submit" value="Search"> </br></br> </form> </body></html> ConnectDB.php <?php $server='d3licsql02'; $connectinfo=array("Database"=>"TestData", "UID" => "sa", "PWD" => "secret"); //connect to DB $conn=sqlsrv_connect($server,$connectinfo); if( $conn === false ) { die( print_r( sqlsrv_errors(), true)); } ?> Any Ideas