osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

Scrolling bestsellers with images

This is a discussion on Scrolling bestsellers with images within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; I had a need to hide my FREE products from the infobox, thus only displaying the bestsellers that actually cost ...


Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > New osCommerce Contributions

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Reply

 

LinkBack Thread Tools
  #1  
Old 05-09-2008, 12:10 PM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,287
Thanks: 66
Thanked 309 Times in 294 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Post Scrolling bestsellers with images

I had a need to hide my FREE products from the infobox, thus only displaying the bestsellers that actually cost more than 0. Here is the query with the needed changes to hide free stuff if anyone needs it :)

if (isset($current_category_id) && ($current_category_id > 0)) {
$best_sellers_query = tep_db_query("select distinct p.products_id, p.products_price, p.products_image, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_price > 0 and p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
} else {
$best_sellers_query = tep_db_query("select distinct p.products_id, p.products_price, p.products_image, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_price > 0 and p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
}

all i added was a check for products price above 0 like this "where p.products_price > 0 and "

njoy!

More...
__________________
Michael Sasek
osCMax Developer


osCMax Templates - Hundreds of premium quality templates. New designs every month!

xShop for osCMax - Windows Based osCMax administration. Improved workflow, security, speed and convenience


osCMax Hosting - From basic hosting to High Availability, Load Balanced arrays, the most experienced osCMax host.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Scrolling Images Carousel With Hotlinks In Header michael_s New osCommerce Contributions 0 03-05-2008 08:14 AM
Scrolling Images Carousel With Hotlinks In Header michael_s New osCommerce Contributions 0 04-25-2007 01:20 PM
Scrolling Text and Images anywhere michael_s New osCommerce Contributions 0 02-02-2007 02:50 AM
help :scrollin bestsellers+images needed eternity575 osCMax v1.7 Discussion 0 03-06-2004 12:00 PM
How to add images to Bestsellers BOX??? stando osCMax v1.7 Discussion 0 01-17-2004 10:41 AM


All times are GMT -8. The time now is 04:29 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax