[gb2world]

Hi again Scott -

It just struck me that you might be using the POS associated with the products within a category, and not the POS associated with the category itself. (There are a lot of POS settings - so it can get confusing!)

Here is more code for another query that gets that POS for product.tpl. Hopefully this displays the variable that you seek. If you have an individual product in more than one category - the query may need to be adjusted.

In product.php:

$cat_order_by = func_query_first_cell("select order_by from $sql_tbl[categories] where categoryid = '$cat'");

$smarty->assign("cat_order_by",$cat_order_by);

$prod_order_by = func_query_first_cell("select orderby from $sql_tbl[products_categories] where productid = '$productid'");

$smarty->assign("prod_order_by",$prod_order_by);

In product.tpl:

category: {$cat}<br />
parent: {$current_category.parentid}<br />
order_by: {$cat_order_by}<br />
productid: {$product.productid}<br />
prod_order_by: {$prod_order_by}<br />