|
Show list of all orders placed by this customer on Order Edit
page.
Use  (Insert PHP code snippet) button
to add this event on the Visual
Editor page.
 Note: Change
the values listed in red to
match your specific needs.
|
global $dal;
$tblOrders = $dal->Table("Orders");
$rs
= $tblOrders->Query("OrderID=".$_REQUEST["editid1"],"");
$data
= db_fetch_array($rs);
$CustomerID = $data["CustomerID"];
echo
"Orders placed by "
.$CustomerID.
"<br>";
$rsOrders = $tblOrders->Query("customerid='".$CustomerID."'","");
while($data=db_fetch_array($rsOrders))
{
echo
"<a target=_blank
href=Orders_edit.php?editid1=".$data["OrderID"].
">". $data["OrderID"]."</a> ".$data["OrderDate"]."<br>";
}
|
For more information about using Data Access Layer (DAL), see
Data Access Layer.
|
