/* ///sql server connection */

 $user="itgasite"; #a valid username
$password="itga1111!"; #a password for the username

$connection = odbc_connect("MSSQLServer", $user, $password);

if ($connection) {
    echo "Connection established.";
} else{
    echo odbc_errormsg();
}


$query = "SELECT CUSTOMER_NAME, TELEPHONE_1, TELEPHONE_3, EMAIL, DATE4, HNUM FROM CUSTOMERS WHERE (CODE_SUG = 2) AND (HNUM = N'10924') AND (COMPANYNUMBER = N'057431397')";
$result = odbc_exec($connection, $query);

debug($result);