Here are some global declarations prior to any function dec in an include file...
//-------
//Declare
//-------
$prm_from_dt="";
$prm_from_dttme="";
$prm_to_dt="";
$prm_to_dttme="";
$prm_asat_dt="";
$prm_asat_dttme="";
$prm_year="";
$prm_month="";
function DayOf($dte)
...and here is some code making use of that \
explode($GLOBALS)
$query=" SELECT ".
" p.ProductKey, p.ProductName, t.trantype, t.tranmodifier, t.trantaxrate,".
" SUM(t.TranQty) AS sumQty, ".
" SUM(t.TranTotalPrice) AS sumPrice, ".
" SUM(t.TranTotalCost) AS sumCost ".
" FROM Transactions t, Orders o, Products p ".
" WHERE t.ProductKey = p.ProductKey ".
" and t.orderkey = o.orderkey ".
" and o.OrderDteTme BETWEEN #".$prm_from_dttme."# AND #".$prm_to_dttme."# ".
" GROUP BY p.ProductKey, p.ProductName, t.trantype, t.tranmodifier, t.trantaxrate ".
" ORDER by p.ProductKey ";