|
|
SELECT
inventoryItems.primaryKey,
inventoryItems.itemNumber,
inventoryItems.itemName,
inventoryItems.itemDescription,
inventoryItems.weight,
inventoryItems.price,
inventoryItems.user1,
inventoryItems.user2,
inventoryItems.user3,
inventoryItems.user4,
inventoryItems.user5,
inventoryItems.quantityOnHand
FROM
inventoryItems
WHERE
primaryKey = #url.item#
|
|
|
SELECT
photoFile
FROM
inventoryPhotos
WHERE
inventoryID = #primaryKey#
ORDER BY
uploadedOn
DESC
|
|
#itemName# |
|
|
|
|
Description: |
#itemDescription#
Botanical Name: #user1#
Country of Origin: #user3#
Distillation Method: #user4#
Uses: #user2#
Size: #user5#
|
|
Weight: |
#weight# |
|
Stock No: |
#itemNumber# |
|
Price:
#dollarFormat(price)#
|
|
|
Availability: |
In Stock -- Ships next business day.
Out of Stock
|
|
|
|
|
|
|
|
|
|
|
|