You could try copying Rod's 3 steps and make the little adjustments I added if needed. For step 2 you could try this
PHP Code:
$products_query_cost = $db->Execute("SELECT products_cost AS unit_cost, products_id FROM ".TABLE_PRODUCTS." WHERE products_id = ".$products->fields['products_id']."") ;
Then in step 3 it would change to
PHP Code:
<td class="dataTableContent" align="right"><?php echo $products_query_cost->fields['unit_cost']; ?> </td>
I haven't tried it, this is just a stab.
Bookmarks