X-Cart forums

[MCM]

Hi,

I'd like to have a simple yes/no extra field for a logic statement. In a template, how do I call this extra field? I've tried $products[product].Reduced but it didn't work. Is there a way to call the extra field (called reduced) or do I have to add a field to my database? If the latter, is there a tutorial available to show me how to add to the database, and then call the variable properly?

Thanks,

Jeremy

[balinor]

Depends on what template you want to call it in. Where do you want it to display?

[PhilJ]

http://forum.x-cart.com/showthread.php?t=26844

[MCM]

Phil,

I tried that, but I couldn't find $query_data = array( ... ); in include/Product_Modify.php, so I didn't know how to continue. I want to call it in the customer/main/products.tpl and just use a logic statement to dictate what should be displayed given the assigned value for each item.

Jeremy

[PhilJ]

That's because you are using v4.0.x, that code is meant for v4.1.x

In /include/product_modify.php look for this instead...

  #
  # Update product data
  #
  db_query("UPDATE $sql_tbl[products] SET product='$product', descr='$descr', fulldescr='$fulldescr', avail='$avail', list_price='$list_price', weight='$weight', productcode='$productcode', forsale='$forsale', distribution='$distribution', free_shipping='$free_shipping', shipping_freight='$shipping_freight', discount_avail='$discount_avail', min_amount='$min_amount', return_time = '$return_time', low_avail_limit='$low_avail_limit', free_tax='$free_tax' WHERE productid='$productid'");

Add the new fields like this...

newfield='$newfield',

HTH

[MCM]

Brilliant! Thanks, Phil!