<?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);

	}

?>