Hi
Should be something like this:
SELECT ListPrice, SalePrice FROM sku WHERE Item = $RelatedItemID
if ($SalePrice)
{
$itemprice=$SalePrice;
}
else
{
$itemprice=$Listprice;
}
Hope this helps
Tom
----- Original Message -----
From: "Jokerjoe" <[EMAIL PROTECTED]>
To: "FreeTrade" <[EMAIL PROTECTED]>
Sent: Sunday, April 08, 2001 9:05 AM
Subject: [FreeTrade] Relationshps and Prices
> I have studied the code for 3 days now and can't seem to figure out how to
> show the price of a related item..I want to have the items that are related
> to another item not only show the name of the item and a link to the item
> but also show that related items price within the table. Make sense? Can
> anyone help?
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Site: http://www.working-dogs.com/freetrade/
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
