Hello,
modules/actions/SET_SHIPPING (240-259)
======================================
//get item total for this shipping address
$tItemCost = 0;
$Query = "SELECT Quantity, ListPrice, SalePrice ";
$Query .= "FROM invoice_sku ";
$Query .= "WHERE ID in ($invoice_sku_IDs) ";
$DatabaseResult = mysql_query($Query, $DatabaseLink);
while($DatabaseRow = mysql_fetch_row($DatabaseResult))
{
$tQuantity = $DatabaseRow[0];
$tListPrice = $DatabaseRow[1];
$tSalePrice = $DatabaseRow[2];
===> $tShipping = $DatabaseRow[3];
if($tSalePrice > 0)
{
$tListPrice = $tSalePrice;
}
$tItemCost += $tQuantity * $tListPrice;
}
=====================================
In the SELECT we only get the Quantity, ListPrice and SalePrice and not
the Shipping.
Regards
--
Antonio M�rmol Albert ( [EMAIL PROTECTED] )
Dpto. T�cnico de Infurma
http://www.infurma.es -- http://www.habitatsearch.com
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
