Hi Professionals
I have the following php file which works and returns data from the database
[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)); } $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 ""; echo $row['software_manufacturer']; echo ""; } sqlsrv_free_stmt( $stmt); ?>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 ""; echo $row['software_manufacturer']; echo ""; } sqlsrv_free_stmt( $stmt); ?>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)); } ?>[/php]
Any Ideas