[N00dles]

Ok got there in the end thanks for your help pointing me in the right direction.
Now no need to look on the front page to see if its been added to the featured produsts or if its out of stock, as I do not show out of stock Items I do not know what has gone missing from the front.

Also the select featured product should have this because I am forever trying to find in stock items by name in the select featured products lists.
I think next I will either make a mod for just adding products to the featured products by productid or sku would be a much easier way, no searching massive lists then finding out its not in stock.

Query

 $products = func_query ("SELECT
 $sql_tbl[featured_products].productid,
 $sql_tbl[products].product,
 $sql_tbl[featured_products].product_order,
 $sql_tbl[featured_products].avail,
 $sql_tbl[products].avail AS in_stock
 from
 $sql_tbl[featured_products],
 $sql_tbl[products]
 where
 $sql_tbl[featured_products].productid=$sql_tbl[products].productid
 AND
 $sql_tbl[featured_products].categoryid='$f_cat'
 order by
 $sql_tbl[featured_products].product_order");

Smarty Tag

{$products[prod_num].in_stock}