Hi,
Which file can I find the SQL Select statement for retrieving the product information from the products table that is then displayed within tpl_product_info_display.php ?
I have added a couple of new columns to the products table and want to include them on the display page.
Thanks
Greg
Thread: Product Select SQL Code
Results 1 to 3 of 3
-
30 Jul 2010, 08:48 AM #1
New Zenner
- Join Date
- Nov 2009
- Posts
- 48
- Plugin Contributions
- 0
Product Select SQL Code
My Server Versions:
Zen Cart 1.3.9h, Apache 2.2.17, PHP 5.2.17, MySQL 5.1.54
-
30 Jul 2010, 09:04 AM #2
Totally Zenned
- Join Date
- Apr 2006
- Location
- London, UK
- Posts
- 10,569
- Plugin Contributions
- 25
Re: Product Select SQL Code
If you've added these fields for use by products that have product_general type, then the SQL will be built in includes/modules/pages/product_info/main_template_vars.php
Kuroi Web Design and Development | Twitter
(Questions answered in the forum only - so that any forum member can benefit - not by personal message)
-
30 Jul 2010, 11:50 AM #3
New Zenner
- Join Date
- Nov 2009
- Posts
- 48
- Plugin Contributions
- 0
Re: Product Select SQL Code
Thank you very muchMy Server Versions:
Zen Cart 1.3.9h, Apache 2.2.17, PHP 5.2.17, MySQL 5.1.54
Similar Threads
-
v139h SQL code to populate a wholesale column as a percentage of the product price.
By ilmarchez in forum Setting Up Categories, Products, AttributesReplies: 3Last Post: 17 Jul 2015, 10:57 PM -
v151 Need an SQL query to select a range of products and update the product status to 0
By oztraveller06 in forum Setting Up Categories, Products, AttributesReplies: 2Last Post: 8 Mar 2014, 07:33 AM -
v139f Edit Product - Select Image will auto select a dropdown selection
By chris_black_hills in forum Setting Up Categories, Products, AttributesReplies: 0Last Post: 15 Jan 2012, 07:42 PM -
SQL Code to Empty All Product Images?
By ryanb4614 in forum General QuestionsReplies: 4Last Post: 9 Sep 2010, 04:08 AM -
Sql Error Code 1064 - SELECT ratio FROM zen_sc_products_ratio (Store Credit mod)
By ejw in forum All Other Contributions/AddonsReplies: 2Last Post: 20 Mar 2008, 04:31 PM
