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
Threaded View
-
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
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
