Difficulty adding Product description to new_products.php

[mohawk]

Hi everyone,

At present I am trying to add the description of each product to the featured products section on the index.php page

any ideas??

I know i need to reference the database product descriptions..

[met00]

I would ask "why?", but something tells me that I won't like the answer.

Look at product_info.php and copy ho it pulls a products description out and then paste that into the location in featured products where you want to add it (actually, it's the query that will have to be changed, because...). Then understand that featured products uses the products_listing from /includes/modules to display and you will have to change how that works so it will add the description to the display (and then you will have a one-off of how you do listing for featured products).

Really a great deal of "one off"-ing a module to do something it really wasn't designed to do.

So, let's start with a bit of requirements definition and ask, what is the end goal that you want to achieve here? Have you considered all the potential downsides? What if the description is 250 words, do you want all of it? Just the fist 300 characters? What if the first 300 characters has an opening tag (like an opening table tag) and you display that without proper closing tags that are at character 500?

Like I said, what you may want is not really featured products, but a way to display a subset of products on a page that is NOT in the current model, but then you had best consider how that would best be done so that you don't trip yourself up when you do display the items (limiting the size of descriptive text, and doing so without creating broken HTML).

[mohawk]

Thanks for your response, I haven't tried implementing the code yet this morning but I will give it a go later when I get time.
Just to answer why do it?

I would like to give the website visitors a quick glance opportunity at 3 products displaying randomly on the homepage(index) featured or new products area.

In the php I would strip out the html tags from the product description and truncate it to display a certain amount of characters, about a line or 2.

The file I am currently working on is the new_products.php located in includes/modules/new_product.php

I'll post back later to let you know if I get it to work

Thanks

[mohawk]

I got it working, however I do see your point, Iv'e stripped the html and limited the chars but it looks a bit messy.

Do you know if i can place the category name for the product in this spot instead of the product description?

[met00]

Sure, just do an sql query against products_to_categories and then display the results.