$uid, "PWD"=>$pwd,'ReturnDatesAsStrings'=> true, "CharacterSet" => 'utf-8', "Database"=>"TruckTracking" ); /* Connect using SQL Server Authentication. */ $conn = sqlsrv_connect( $serverName, $connectionInfo); if( $conn === false ) { echo "Unable to connect.
"; die( print_r( sqlsrv_errors(), true)); } $sql = "SELECT SUM(NetWt) AS totalwt, SUM(CASE WHEN DumpLocation='Truck Dump' THEN NetWt END) AS truckwt FROM DumpHistory"; $stmt = sqlsrv_query( $conn, $sql ); if( $stmt === false) { die( print_r( sqlsrv_errors(), true) ); } $array=sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC); echo $array['totalwt']; echo "
"; echo $array['truckwt']; ?>