OK, I changed the recordset to be
$query_Products = "SELECT products.*, productcategories.CategoryName, productcategories.Live FROM products INNER JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID"
I wasnt sure what or how to add the further refernce to the 'Live' column from productcategories.
Then I wrapped the results in a show if based on Live=1 (from productcategories) but when I did a search no results showed at all.
If you go to http://hairmekanix.co.uk/sections.php
search Travel - this is a category which is hidden in the database but has a product associated with it. The product itself is set to live.
What I am trying to get it to do is to hide products even if they are 'live' if the category is set to hidden.