Variable Help!!

[aking1001]

Hi, I'm new with osCMax and could use a bit of help.

My customer wanted a field when he was adding new products that would indicate by what measure they were being sold (ex - by box, by pound, by kilogram, by the dozen, etc).

I have successful added a new form field to the admin page categories.php and I have it saving the data to a new field in the database. So far so good!

However, I can NOT get the new information to display on the front end by editing product_info.tpl.php

I am using a piece of code identical to this:

<?php echo $products_format; ?>

I believe the data isn't being initialized / captured / loaded as a variable I can display.

HELP!!

[ridexbuilder]

You need to retrieve the data, along with everything else, in the select statement.

[wowsaver]

if you have your new field added to products table:

    $product_info_query = tep_db_query("select p.products_format,p.products_id, pd.products_name, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
    $product_info = tep_db_fetch_array($product_info_query);

if you have your new field added to products description table:

    $product_info_query = tep_db_query("select pd.products_format,p.products_id, pd.products_name, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
    $product_info = tep_db_fetch_array($product_info_query);

[aking1001]

Thanks for the responses.

It's in the products table. I have added the code as wowsaver suggested -- still nothing!

[pgmarshall]

If you read the post again you will notice.

if you have your new field added to products description table

Whereas you have put the extra field in the products table not products_description.

Just change the select to be p.products_format not pd.products_format

Regards,

[aking1001]

The product_info_query uses p.products_format. No luck.

On the product_info.tpl.php page I've tried:

<?php echo $products_price; ?> -- nothing;

<?php echo $p.products_price; ?> -- prints the term "products_price"

<?php echo $products_info['products_format']; ?> -- nothing;

[wowsaver]

let's say your new field is in products table with the field name products_format

Use this statement in your product_info.tpl.php
(replace the one at about line 33)

$product_info_query = tep_db_query("select p.products_format,p.products_id, pd.products_name, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
    $product_info = tep_db_fetch_array($product_info_query);

then echo:

<?php $product_info['products_format']; ?>

If you have still problems make sure your cleared your cache and your cookies.
check in your database that you actually have the field products_format in your products table and see if you have any value for this field.

[aking1001]

Wowsaver, you are a lifesaver! It finally worked!

Thanks very much!!

[pgmarshall]

Glad to hear you got it to work ...

Don't forget to click the button (bottom right) to say "thanks" to wowsaver.

Regards,