[carlisleglass]

remove the following from the statement

AND $sql_tbl[extra_fields].active='Y'

and it will pick up all your extra fields not just the active ones (in other words the ones with the show box ticked).

You can also put the same statement in your featured_products.php so that extra fields are available to them as well.

UPDATE: add again the same coding into include/search.php just above $smarty->assign("products",$products); and you will have extra fields in your search results also.