Hi, this code is prety simple, it just query for a Inventory quantity, using php+freetds+unixodbc, and works well as I provided here, the thing is that when I put this code inside a homemade php sofware... it just returns null, none, blank, nothing... how can I workaround this?
Thanks in advance.
<?php
$code = '20005-FRD';
include "/usr/local/www/data/scripts/db_stuff/db_secrets.php";
$conn=odbc_connect($pos_host,$pos_user,$pos_pass);
$queryRMSqty1 = "SELECT Quantity FROM Custom_Piso_Qty WHERE SubDescription3 = '".$code."'";
$rs_RMS1=odbc_exec($conn,$queryRMSqty1);
$RMS_qty1=odbc_result($rs_RMS1,'Quantity');
echo $RMS_qty1;
odbc_free_result($rs_RMS1);
odbc_close($conn);
?>
Aldo