Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product Extra Fields & Family Products MS2


versatilewt

Recommended Posts

I'm currently trying to draw one of the product extra fields that I created and post it after the quantity field in both the normal product_listing.php page and the family products listing on the product_info.php page.

 

My products are sold by cartons that go by sq ft and accessories that go by lineal feet or units, and i want to have that listed after the quantity box.

 

I was able to make this display on the product_info.php page after I added a quantity box, but can't get it to work with the product_listing.php page.

 

Here is how I got it to display on the product_info.php page:

 

<?php 
$units_query=mysql_query("SELECT  products_extra_fields_value FROM `products_to_products_extra_fields` WHERE products_id='$product_info[products_id]' AND products_extra_fields_id='17'");
$getunits=mysql_fetch_array($units_query);
echo "$getunits[products_extra_fields_value]"; ?>

 

Some help please?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...