osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

Improve Product Attributes/Item Editor

This is a discussion on Improve Product Attributes/Item Editor within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; I love the idea of this cont., Sergey Polischuk has a small SQL mistake in his cont. on line 33 ...


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
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 02-14-2007, 12:00 PM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 10,992
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 Improve Product Attributes/Item Editor

I love the idea of this cont., Sergey Polischuk has a small SQL mistake in his cont.

on line 33 written:
$suboptions = tep_db_query("SELECT DISTINCT POV.products_options_values_id, POV.products_options_values_name FROM products_options_values POV, products_options_values_to_products_options POVtoPO WHERE language_id = '" . $languages_id . "' AND POVtoPO.products_options_id = '" . $options_values['products_options_id'] . "' AND POVtoPO.products_options_values_id = POV.products_options_values_id ORDER BY POV.POV.products_options_values_id");

the last sql line have an extra POV, it should be replace with this SQL:

$suboptions = tep_db_query("


SELECT DISTINCT
POV.products_options_values_id,
POV.products_options_values_name
FROM
products_options_values POV,
products_options_values_to_products_options POVtoPO
WHERE
language_id = '" . $languages_id . "'
AND
POVtoPO.products_options_id = '" . $options_values['products_options_id'] . "'
AND
POVtoPO.products_options_values_id = POV.products_options_values_id
ORDER BY
POV.products_options_values_id");

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!
Sponsored Links
Advertisement
Closed Thread

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
Item/Product onto PayPal Notification ozstar osCMax v2 Customization/Mods 1 12-15-2006 10:20 AM
product/category description shows FCK editor url Dumb_Question osCMax v2 Features Discussion 7 01-01-2006 01:11 PM
Specific Product Image based on chosen product attributes? chrisrex osCMax v2 Customization/Mods 0 11-22-2005 09:41 AM
Product Attributes Specify New Item # adamr415 osCMax v1.7 Discussion 1 08-13-2005 09:26 PM
Product item # peter osCommerce 2.2 Modification Help 0 08-11-2003 11:07 PM


All times are GMT -8. The time now is 08:41 AM.


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