Another (But Related) Variable Issue!

[aking1001]

Thanks to forums members I now have the variable I needed displaying on individual product_info.php pages. See this thread

Now I need that same variable to also display on the index.php page.

I am editing the includes - modules - product_listing_col.php page.

I have managed to get a static piece of text to display by adding it to one of the cases but trying to add a case to the array with my variable included has gotten me nowhere.

Any suggestions?!!

[wowsaver]

you will have to add a configuration key in your configuration table.

[aking1001]

Thanks for the response Wowsaver but I'm not sure I quite follow... could you elaborate?

I have products_format added to the Products table in the database. The other values that are displayed on the Product Listings page appear to be drawn from values in this table. I found the configuration key in the Configuration table but don't quite follow how this relates or what I should enter??

(Sorry for being dense!)

[met00]

okay, the way you added it before was to change the query

$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);

to get the data. Have you changed the queries to get the data you wish to display? If not then the data is not being picked up in the query and therefore NOT going to display.

[aking1001]

I tried to change the query but the structure of the Product Listing page is built in an array and I am having trouble finding where to edit the query or queries to allow the data to display correctly.