> I am trying to get the search results to alos show the price of an itme. I
> don't want people to search by price, but I want them to see the price in
> the results. I have worked at the code all afternoon and the best I can get
> is that the item display multiple times but no prices.
Prices are associated with SKUs, whereas the search results is concerned
with items. Hence, if you get a successful search result, it is for an
item, which may contain multiple SKUs each of a different price. If
this is is okay by you, you should change the query that gets the items
from the database so that it does a JOIN with the SKU table so that it
can get the prices associated with each SKU in the item. Hence, the
query might look something like, "SELECT i.ID, s.ID, i.Name, s.Name,
s.ListPrice, s.SalePrice, i.Description, i.Thumbnail, i.Keywords FROM
item i, sku s WHERE Active = 'Y' AND s.Item=i.ID ORDER BY
i.DisplayPrecedence, s.DisplayPrecedence, i.Name, s.Name".
Hope that helps. It was a good question.
-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]
