Turn a field on/off in product listing

[rwoody]

I've created a new product type that merely added one field. I've also coded product_listing to display the field on the listing page. 90% of the customer's products will need this field, but there are a few to include Gift Cards (Gift Certificates) that I would rather not have it show.

Is there a bit of code that could be added to the template that could detect the product type and if not product_type 6 don't display field?

I'm not quite sure how to go about this. Any suggestions would be greatly appreciated.

[Ajeh]

You would need to customize the product listing files so that when the products_type is not your new Product Type the individual listing will exclude that field ...

[poolprorich]

$query = "SELECT your_field, FROM your_table WHERE product_type='6' and products_status='1' ;
$result = mysql_query($query) or die(mysql_error());
// Print out result
while($row = mysql_fetch_array($result)){
echo $row['your_field to be displayed'];



}

?>