Customizing Product Listing Page

[mc12345678]

thank you, I did notice that. Please see the last post, any ideas? or here is where I'm at. Produces this http://vermontindexable.com/indexabl...&cPath=3_27_46

still working on this

here is what is in my english.php

PHP Code:
// specials box text in sideboxes/specials.php
define('BOX_HEADING_SPECIALS', 'Specials');
define('CATEGORIES_BOX_HEADING_SPECIALS','Specials ...');
define('TABLE_HEADING_SHORT_DESC','Specials ...');

define('TABLE_HEADING_SHORT_DESCC','Specials ...');

define('TABLE_HEADING_SHORT_DESC3','Specials ...');
define('TABLE_HEADING_SHORT_DESC4','Specials ...');


here is what is in my main_template_vars @ /vermontindexable.com/indexable-tools/includes/modules/pages/index

PHP Code:
// create column list
$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
'TABLE_HEADING_SHORT_DESC' => TABLE_HEADING_SHORT_DESC,
'TABLE_HEADING_SHORT_DESCC' => TABLE_HEADING_SHORT_DESCC,
'TABLE_HEADING_SHORT_DESC3' => TABLE_HEADING_SHORT_DESC3,
'TABLE_HEADING_SHORT_DESC4' => TABLE_HEADING_SHORT_DESC4,


'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE);

/* ,
'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);
*/
asort($define_list);
reset($define_list);
$column_list = array();
foreach ($define_list as $key => $value)
{
if ($value > 0) $column_list[] = $key;
}

$select_column_list = '';

for ($i=0, $n=sizeof($column_list); $i<$n; $i++)
{
switch ($column_list[$i])
{
case 'PRODUCT_LIST_MODEL':
$select_column_list .= 'p.products_model, ';
break;
case 'PRODUCT_LIST_NAME':
$select_column_list .= 'pd.products_name, ';
break;

case 'PRODUCT_LIST_MANUFACTURER':
$select_column_list .= 'm.manufacturers_name, ';
break;

case 'PRODUCT_LIST_SHORT_DESC':
$select_column_list .= 'pd.products_short_desc, ';
break;

case 'PRODUCT_LIST_SHORT_DESCC':
$select_column_list .= 'pd.products_short_descc, ';
break;

case 'PRODUCT_LIST_SHORT_DESC3':
$select_column_list .= 'pd.products_short_desc3, ';
break;
case 'PRODUCT_LIST_SHORT_DESC4':
$select_column_list .= 'pd.products_short_desc4, ';
break;

and what is in my productlisting- at /vermontindexable.com/indexable-tools/includes/modules/modern_blue

PHP Code:
$zc_col_count_description = 0;
$lc_align = '';
for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
switch ($column_list[$col]) {
case 'PRODUCT_LIST_MODEL':
$lc_text = 'Part Name';
$lc_align = '';
$zc_col_count_description++;
break;
case 'PRODUCT_LIST_NAME':
$lc_text = TABLE_HEADING_PRODUCTS;
$lc_align = '';
$zc_col_count_description++;
break;
case 'PRODUCT_LIST_SHORT_DESC':
$lc_text = TABLE_HEADING_SHORT_DESC;
$lc_align = '';
$zc_col_count_description++;
break;
case 'PRODUCT_LIST_SHORT_DESCC':
$lc_text = TABLE_HEADING_SHORT_DESCC;
$lc_align = '';
$zc_col_count_description++;
break;

case 'PRODUCT_LIST_SHORT_DESC4':
$lc_text = TABLE_HEADING_SHORT_DESC4;
$lc_align = '';
$zc_col_count_description++;
break;case 'PRODUCT_LIST_SHORT_DESC3':
$lc_text = TABLE_HEADING_SHORT_DESC3;
$lc_align = '';
$zc_col_count_description++;
break;
case 'PRODUCT_LIST_MANUFACTURER':
$lc_text = TABLE_HEADING_MANUFACTURER;
$lc_align = '';
$zc_col_count_description++;
break;
case 'PRODUCT_LIST_PRICE':
$lc_text = TABLE_HEADING_PRICE;
$lc_align = 'right' . (PRODUCTS_LIST_PRICE_WIDTH > 0 ? '" width="' . PRODUCTS_LIST_PRICE_WIDTH : '');
$zc_col_count_description++;
break;
case 'PRODUCT_LIST_QUANTITY':
$lc_text = TABLE_HEADING_QUANTITY;
$lc_align = 'right';
$zc_col_count_description++;
break;
case 'PRODUCT_LIST_WEIGHT':
$lc_text = TABLE_HEADING_WEIGHT;
$lc_align = 'right';
$zc_col_count_description++;
break;
case 'PRODUCT_LIST_IMAGE':
$lc_text = TABLE_HEADING_IMAGE;
$lc_align = 'center';
$zc_col_count_description++;
break;
}

if ( ($column_list[$col] != 'PRODUCT_LIST_IMAGE') ) {
$lc_text = zen_create_sort_heading($_GET['sort'], $col+1, $lc_text);
}



$list_box_contents[0][$col] = array('align' => $lc_align,
'params' => 'class="productListing-heading"',
'text' => $lc_text );
}

if ($listing_split->number_of_rows > 0) {
$rows = 0;
$listing = $db->Execute($listing_split->sql_query);
$extra_row = 0;
while (!$listing->EOF) {
$rows++;

if ((($rows-$extra_row)/2) == floor(($rows-$extra_row)/2)) {
$list_box_contents[$rows] = array('params' => 'class="productListing-even"');
} else {
$list_box_contents[$rows] = array('params' => 'class="productListing-odd"');
}

$cur_row = sizeof($list_box_contents) - 1;

for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
$lc_align = '';

switch ($column_list[$col]) {
case 'PRODUCT_LIST_SHORT_DESC':
$lc_align = '';
$lc_text = $listing->fields['products_short_desc'] . '&nbsp;';
break;
case 'PRODUCT_LIST_SHORT_DESCC':
$lc_align = '';
$lc_text = $listing->fields['products_short_descc'] . '&nbsp;';
break;
case 'PRODUCT_LIST_SHORT_DESC3':
$lc_align = '';
$lc_text = $listing->fields['products_short_desc3'] . '&nbsp;';
break;
case 'PRODUCT_LIST_SHORT_DESC4':
$lc_align = '';
$lc_text = $listing->fields['products_short_desc4'] . '&nbsp;';
break;
case 'PRODUCT_LIST_NAME':
$lc_align = '';

I'll be honest, I'm getting a little lost with what it is you're trying to do with what you have. So, right off the bat I can see that there is a problem in /vermontindexable.com/indexable-tools/includes/modules/pages/index

In the define_list, there are these different TABLE... Variables, but then below there is a case select to look for the PRODUCT... Version. Those cases never run, because they are not in the define... Seems to me that the code was closer to running the first time than now. After that error, I pretty much stop looking because even then I don't think that the table defines are what you are looking for there, but perhaps you are...

Need to follow the logic and the assignments from top to bottom and file to file. And to get the result you want you almost have to work backwards.