Zen Cart Logo
Forums / General Questions / Product Select SQL Code

Product Select SQL Code

Locked

Started by gregger on 30 Jul 2010, 7:48 AM · Views: 739

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
30 Jul 2010, 7:48 AM
#1
gregger avatar

gregger

New Zenner

Join Date:
Nov 2009
Posts:
48
Plugin Contributions:
0

Product Select SQL Code

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

My Server Versions:
Zen Cart 1.3.9h, Apache 2.2.17, PHP 5.2.17, MySQL 5.1.54

30 Jul 2010, 8:04 AM
#2
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

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, 10:50 AM
#3
gregger avatar

gregger

New Zenner

Join Date:
Nov 2009
Posts:
48
Plugin Contributions:
0

Re: Product Select SQL Code

:clap::clap::clap:

Thank you very much

My Server Versions:
Zen Cart 1.3.9h, Apache 2.2.17, PHP 5.2.17, MySQL 5.1.54