osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

Show All Products in Category & Subcategories V1.0

This is a discussion on Show All Products in Category & Subcategories V1.0 within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; to fix the SQL error of unkown field "select distinctp blah blah blah you have to goto the "we show ...


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

Show All Products in Category & Subcategories V1.0 Show All Products in Category & Subcategories V1.0

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Reply

 

LinkBack Thread Tools
  #1  
Old 04-14-2008, 09:01 PM
michael_s's Avatar
osCMax Developer

  
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,967
Thanks: 80
Thanked 345 Times in 324 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 Show All Products in Category & Subcategories V1.0
to fix the SQL error of

unkown field "select distinctp blah blah blah

you have to goto the "we show them all" part for product categories *(not manufacturers)

and add a 'space' (thats one spacebar) after "select distinct"

so it will be "select distinct "

yah easy fix...

now it works!!

good mod!


here is the new instructions with the fix added.

this one is verified working.


More...
__________________
Michael Sasek
osCMax Developer

  • osCMax Templates - Hundreds of premium quality templates designed for osCMax 2. Loyalty discounts up to 30% off!
    Each purchase supports the osCMax project with much needed funds!
  • 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. Default multi server configuration for exceptional performance!

  • osCMax Template Tutorial - Learn how to make your own custom templates and how to use the powerful features of the osCMax template system.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Advertisement
Reply

« If price = 0.00 dont display price | osCDark »
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
Show All Products in Category & Subcategories V1.0 michael_s New osCommerce Contributions 0 11-11-2007 12:01 PM
Show All Products in Category & Subcategories V1.0 michael_s New osCommerce Contributions 0 08-26-2007 01:23 PM
Show All Products in Category & Subcategories V1.0 michael_s New osCommerce Contributions 0 08-25-2007 07:14 AM
Show All Products in Category & Subcategories V1.0 michael_s New osCommerce Contributions 0 08-20-2007 09:14 PM
Show All Products in Category & Subcategories V1.0 michael_s New osCommerce Contributions 0 08-10-2007 03:12 PM


All times are GMT -8. The time now is 12:44 AM.

osCMax Home - Site Map - Top

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