displaying the postage wight or price in product info

[Guest]

http://kb-online.co.uk/shoptester

 

above is not live my live store is http://shop.kb-online.co.uk

i am upgrading and redesigning !

 

any one help i am trying to insert the postage price or wight in the product info pages (the product listing)

not the index product listing pages !

 

i prefer the postage price to be listed but if wight is easier that's fine !

 

i tryed :

 

	<tr><td><b><span class=cs5>Wight:</span>  <span class=cs4><?php echo $products_weight; ?></span><td></tr>

 

just displays the wight:

 

http://kb-online.co.uk/shoptester

 

cheers :)

[Guest]

basically i require the wight or postage price on the product listing page ! i use the table prices

i am creating a new version of my current store

to access this see http://kb-online.co.uk/shoptester

 

any help will be very appreciated !

 

the above post just displays the name 'wight:' not the actual wight.

 

regards

[Nullachtfuffzehn]

basically i require the wight or postage price on the product listing page ! i use the table prices

i am creating a new version of my current store

to access this see http://kb-online.co.uk/shoptester

 

any help will be very appreciated !

 

the above post just displays the name 'wight:' not the actual wight.

 

regards

 

You need to add p.products_weight to the $product_info_query to retrieve the data from the database. The stock version doesn't retrieve this information.

[Guest]

You need to add p.products_weight to the $product_info_query to retrieve the data from the database. The stock version doesn't retrieve this information.

 

rite cheers how do i go about that ?

 

thanks so much for the help !

[Nullachtfuffzehn]

rite cheers how do i go about that ?

 

thanks so much for the help !

 

In the stock version the mentioned query is located in line 80, dunno what you've altered so far. It looks like the following:

 

    $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, 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 . "'");

 

Your required query should look like this:

 

    $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_weight, 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 . "'");

 

Hope that helps.

[Guest]

Your required query should look like this:

 

 

Hope that helps.

 

 

cheers still not working i added the replacement to product_info.php

 

i have added to display the weight.

 

	 <tr><td><b><span class=cs5>Weight:</span></b>  <span class=cs4><?php echo $products_weight; ?></span></td></tr> 

 

is this right, well its not working so take it, its not

 

thanks for your help agian !

[Nullachtfuffzehn]

Ok, my bad, I forgot something...

 

	 <tr><td><b><span class=cs5>Weight:</span></b>  <span class=cs4><?php echo $product_info['weight']; ?></span></td></tr> 

 

 

This one should display the weight.

[Guest]

thank you worked

had to change that '$product_info['weight']' to $product_info['products_weight']

 

now works thank you VERY much !

 

very much appreciated !

 

good luck.

[Nullachtfuffzehn]

thank you worked

had to change that '$product_info['weight']' to $product_info['products_weight']

 

now works thank you VERY much !

 

very much appreciated !

 

good luck.

 

You're welcome.

 

Did I mention that I'm taking $5/minute? I'll send you my bank account information via pm.

 

j/k

 

Glad that I could help you.