Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $conn = odbc_connect("Driver={SQL Server};Server=server2;Database=omsdata;", "sa", "3eadquZ");
- $saleDate = sprintf("%0.0f", $time / (60 * 60 * 24) + 61729);
- $queryInsBuy = "INSERT INTO retailSales (invsNum, prod_cd, descrip, price, tax, qty, cost, line, saleDate, saleTime)
- VALUES (999999, '23-er45', 'descrip', 45.99, .3768, 1, , , , )";
- $resInsBuy = odbc_exec($conn, $queryInsBuy) or die (odbc_errormsg());
- echo $queryInsBuy;
- $sql = "SELECT * FROM retailSales WHERE invsNum = '15495' ";
- //$sql = "SELECT * FROM invList WHERE id = '4951' ORDER BY seq ASC";
- $rs = odbc_exec($conn, $sql);
- while ( $row = odbc_fetch_array($rs) )
- {
- print_r($row);
- }
- ?>
Add Comment
Please, Sign In to add comment