sugar
-
Posts
3 -
Joined
-
Last visited
Never
sugar's Achievements
Newbie (1/5)
0
Reputation
-
your webserver is a windows or unix box?
-
Connection to MSSQL from PHP on linux server...
sugar replied to newbie11's topic in Microsoft SQL - MSSQL
you better choose dedicated hosting or VPS -
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