emilianoc 0 Posted November 11, 2002 Hello I made some modifications to the Featured Products mod that I will upload as a new version, but I need some help to finish it. With this contribution you can set a short description for every product, and the idea is to show this short description in the default page. Everything works great! I can create new products with a short description or not in every language set in the site, I can previsualize the new product, or update it. But (yes.. there is allways a but!) In catalog/includes/modules/featured_products_short.php (is a modification of featured_products.php) is where I have the code that shows the list of featured products in default.php <td valign="top" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products_array[$i]['id'], 'NONSSL') . '"><b><u>' . $featured_products_array[$i]['name'] . '</u></b></a><br>' . '<br>' . TEXT_PRICE . ' ' . $products_price; ?></td> I'd like to show the short description in that cell.. but I can't do it! I know that I have to take the value from catalog/includes/modules/featured_products.php $featured_products_query = tep_db_query($featured_products_query_raw); while ($featured_products = tep_db_fetch_array($featured_products_query)) { $featured_products_array[] = array('id' => $featured_products['products_id'], 'name' => $featured_products['products_name'], 'shortdescription' => $featured_products['products_shortdescription'], 'image' => $featured_products['products_image'], 'price' => $featured_products['products_price'], 'specials_price' => $featured_products['specials_new_products_price'], 'tax_class_id' => $featured_products['products_tax_class_id'], 'manufacturer' => $featured_products['manufacturers_name']); } But if I add $products_shortdescription or $featured_products_array[$i]['shortdescription'] nothing seems to be working.. Some help? Emiliano my english really sucks.. but i hope that someone could understand what i'm trying to say... Share this post Link to post Share on other sites
CC 0 Posted November 12, 2002 I understand you, and I agree this would be a fantastic addition. But... As the English say, I'll be buggered if I can help you. :lol: I hope someone can cos this would be great. Usually Matice is good for help about now... Yoo Hooo Mattice, you there?? :wink: CC. Share this post Link to post Share on other sites
emilianoc 0 Posted November 12, 2002 I made my first ever contribution!!!!! woooohoooooo :D :D At the moment I'm with many exams at the university, but later I will upload the contribution as a package.. just wait, it's really a great contribution, I'm sorprised that I made it!! Cheers Emiliano Share this post Link to post Share on other sites
CC 0 Posted November 12, 2002 Nice one mate. Did you get any help in the end? Or did you manage it alone? Cant wait to see it, I hope everyone likes it. CC. Share this post Link to post Share on other sites
emilianoc 0 Posted November 12, 2002 I do it myself!!! emiliano Share this post Link to post Share on other sites
bdownes 0 Posted November 20, 2002 Anyone know what this is? Getting this on catalog/default.php page - the admin side is working great. 1064 - You have an error in your SQL syntax near 'rand() DESC limit 9' at line 1 select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 9 [TEP STOP] Jared Geesey Share this post Link to post Share on other sites
bdownes 0 Posted November 20, 2002 HTTP Server: Apache/1.3.26 (Unix) PHP/4.2.2 FrontPage/4.0.4.3 PHP Version: 4.2.2 (Zend: 1.2.0) Is what my server is configured as. Thanks, Jared Geesey Share this post Link to post Share on other sites