Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

prvhk3

Pioneers
  • Posts

    25
  • Joined

  • Last visited

Profile Information

  • Real Name
    Praveen H K

prvhk3's Achievements

  1. Thank you so much Jack. I will wait for your support. But really it is very important to me...... Thanks in advance
  2. Can you please let me know how did you make this change? From '-' to '/'
  3. Hi, If i change $cName = $result['parentName'] . '-' . $cName; to $cName = $result['parentName'] . '/' . $cName; not working, please let me know what else need to be changed Thanks in Advance
  4. Hi, I have installed Ultimate SEO URL by Chemo 2.2 I need to change the URL Separator to '/' from '-' what should be done and where, please help me ASAP.... Please reply me, as i need help sincerely. I have seen most of the pages in this thread but was unable to find it, if you guys can help me it will be great full. Thanks in Advance.Report
  5. Please anyone help me to change the Separator from '-' to '/'. This is very urjent to me. Thanks in advance........................
  6. Please let me know the solution to the changes separator from '-' to '/'
  7. Hi, please help in URL issue. I have installed Ultimate SEO URLs i need slash has a separator in the URL instead of dash, unable to do it please help me. what should i change and where should i change to get slash has the separator. Present URL: http://localhost/catalog/catgegory-sub-category-manufacturer-product-p-29.html Required URL: http://localhost/catalog/catgegory/sub-category/manufacturer/product-p-29.html please help Thanks in advance
  8. Hello all, I'm working with http://addons.oscommerce.com/info/6339 I love this add-on it is so simple to install and does exactly what I want, except for one thing. It displays the product image and then just the price underneath it. I would like it to display image, product short discription, price. I've been fiddling with the code for a day and I'm just not experienced enough to make it work. I'm sure it's simple for someone out there, Thank you, PRV Contribution Code <?php /* $Id: new_products.php 1806 2008-01-11 22:48:15Z hpdl $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2008 osCommerce Released under the GNU General Public License */ ?> <!-- new_products //--> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B'))); new contentBoxHeading($info_box_contents); if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $category_query = tep_db_query("select distinct categories_id from ". TABLE_products_TO_CATEGORIES ); $cids = array(); while ($categories = tep_db_fetch_array($category_query)) { array_push($cids, $categories["categories_id"]); } $cid = $cids[rand(0, count($cids) - 1)]; // removed order by p.products_date_added desc $new_products_query = tep_db_query( "select p.products_id, p.products_image, p.products_tax_class_id, " . "if(s.status, s.specials_NEW_products_price, p.products_price) as products_price " . "from " . TABLE_products . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id " . ", ". TABLE_products_TO_CATEGORIES . " p2c " . "where p.products_id = p2c.products_id and products_status = '1' and (p2c.categories_id = 54)" . "order by rand() limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_NEW_products_price, p.products_price) as products_price from " . TABLE_products . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_products_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by rand() limit " . MAX_DISPLAY_NEW_PRODUCTS); } $row = 0; $col = 0; $info_box_contents = array(); while ($new_products = tep_db_fetch_array($new_products_query)) { $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id']))); $col ++; if ($col > 2) { $col = 0; $row ++; } } new contentBox($info_box_contents); ?> <!-- new_products_eof //--> Product Short Description is in different table so i have to call TABLE_PRODUCT_DESCRIPTION but if use i get the Sql Error so please help me how to call the Product Short Description in this contribution. This Product Short description is from SEO Header Tags contribution Thanks in advance
  9. Same problem but instead of Product Name i need to display Product short description Product Short Description is in different table so i have to call TABLE_PRODUCT_DESCRIPTION but if use i get the Sql Error so please help me how to call the Product Short Description in this contribution. Thanks in advance.
  10. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 select count(distinct p.products_date_added) as total from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c, categories_description cd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.categories_id = cd.categories_id and ((pd.products_name like '%64%' or p.products_model like '%64%' or m.manufacturers_name like '%64%') I get this error if i search any thing on my website. Please help to solve the error ASAP. Thanks in advance.
×
×
  • Create New...