> Hello List Members,
>
> Has anybody made it so the Item name rather than the sku name appears in the
> side bar shopping basket? Or does anyone have any ideas on how this could be
> done?
>
> Kind Regards,
> Paul Ashton
Paul,
Edit the modules/navigation/basket file and change the query to:
$Query = "SELECT ss.Quantity, s.ID, s.Name,".
"s.ListPrice, s.SalePrice ";
$Query .= "FROM session_sku ss, sku s ";
$Query .= "WHERE ss.SKU = s.ID ";
$Query .= "AND ss.Session = '$sid' ";
to something like:
$Query = "SELECT ss.Quantity, s.ID, i.Name, ".
"s.Name, s.ListPrice, s.SalePrice ";
$Query .= "FROM session_sku ss, sku s, item i ";
$Query .= "WHERE ss.SKU = s.ID ";
$Query .= "AND ss.Session = '$sid' ";
$Query .= "AND s.Item = i.ID";
Then, change the corresponding code that parses the $row, output the new
variable.
Best Regards,
-jj
--
if (shannon - jj) * behrens == webEngineer["CLEAR INK�"]:
print "<i>imagination is the only real medium(sm)</i><br>"
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
