Model In Shopping Cart

[mayomx]

Does anyone know how to display the product model in the shopping cart before checking out?

[Guest]

Does anyone know how to display the product model in the shopping cart before checking out?

 

what you could do is go to where your sql statement is, around line 89, and add a little bit to it. You would need to add p.products_model and the table TABLE_PRODUCTS . " p", so it would look like this:

$attributes = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix, p.products_model 
								  from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS . " p
								  where pa.products_id = '" . (int)$products[$i]['id'] . "'
								   and pa.options_id = '" . (int)$option . "'
								   and pa.options_id = popt.products_options_id
								   and pa.options_values_id = '" . (int)$value . "'
								   and pa.options_values_id = poval.products_options_values_id
								   and popt.language_id = '" . (int)$languages_id . "'
								   and poval.language_id = '" . (int)$languages_id . "'");

 

And then a few lines down you would need to add

 

$products[$i][$option]['products_model'] = $attributes_values['products_model'];

 

and after that you should be good to go... I hope... heh