Loaded Commerce Community

Hi I'm having another problem with displaying 'specials' & 'new products' on my site. Whenever i click on them I'm getting this error: "1109 - Unknown table 'p' in field list select count(p.products_id) as total :

The code for the product_listing_col.php is listed below:

<?php
<?php
/*
$Id: product_listing_col.php,v 1.1.1.1 2004/03/04 23:41:11 ccwjr Exp $
*/
?>


<?
$listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id');

if ( ($listing_split->number_of_rows > 0) && ( (PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3') ) ) {
?>



<table width="100%" class="result">
<tr>
<td align="left" width="50%">
<?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?>
</td>
<td align="right" width="50%" class="result_right">
<?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?>
</td>
</tr>
</table>


<?php
}
$counter = 0;
echo ' <table width="100%" cellspacing="0" cellpadding="0" border="0">
<tr>
<td>
<table width="100%" cellspacing="0" cellpadding="0" border="0" class="product">
<tr>
<td align="right" colspan="12">
<img src="'.DIR_WS_TEMPLATES . TEMPLATE_NAME.'/images/gl.gif" alt="" align="top" /><br /><br style="line-height:12px" />
</td>
</tr>
<tr>';

$list_box_contents = array();

if ($listing_split->number_of_rows > 0) {
$listing_query = tep_db_query($listing_split->sql_query);

$row = 0;
$num = 0;
$column = 0;
$colums=0;
while ($listing = tep_db_fetch_array($listing_query)) {



$product_contents = array();

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

switch ($column_list[$col]) {
case 'PRODUCT_LIST_MODEL':
$lc_align = '';
$lc_text = '&nbsp;' . $listing['products_model'] . '&nbsp;';
break;
case 'PRODUCT_LIST_NAME':
$lc_align = '';
$lc_text = '&nbsp;<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a>&nbsp;';
break;
case 'PRODUCT_LIST_MANUFACTURER':
$lc_align = '';
$lc_text = '&nbsp;<a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $listing['manufacturers_id']) . '">' . $listing['manufacturers_name'] . '</a>&nbsp;';
break;
case 'PRODUCT_LIST_PRICE':
$lc_align = 'right';
if (tep_get_products_special_price($listing['products_id'])) {
$lc_text = '&nbsp;<s>' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</s>&nbsp;&nbsp;<span class="productSpecialPrice">' . $currencies->display_price(tep_get_products_special_price($listing['products_id']), tep_get_tax_rate($listing['products_tax_class_id'])) . '</span>&nbsp;';

} else {
$lc_text = '&nbsp;' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '&nbsp;';
}
break;
case 'PRODUCT_LIST_QUANTITY':
$lc_align = 'right';
$lc_text = '&nbsp;' . $listing['products_quantity'] . '&nbsp;';
break;
case 'PRODUCT_LIST_WEIGHT':
$lc_align = 'right';
$lc_text = '&nbsp;' . $listing['products_weight'] . '&nbsp;';
break;
case 'PRODUCT_LIST_IMAGE':
$lc_align = 'center';
if (isset($HTTP_GET_VARS['manufacturers_id'])) {
$lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>';
} else {
$lc_text = '&nbsp;<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>&nbsp;';
}
break;
case 'PRODUCT_LIST_BUY_NOW':
$lc_align = 'center';
$lc_text = '<a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']) . '">' . tep_template_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a>&nbsp;';
break;
}
$product_contents[] = $lc_text;

}
$lc_text = implode('<br>', $product_contents);
$list_box_contents[$row][$column] = array('align' => 'center',
'params' => 'class="productListing-data"',
'text' => $lc_text);

$product_listing_query_description = tep_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$listing['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

$product_listing_description = tep_db_fetch_array($product_listing_query_description);



$r_name = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a>';

$r_pic = tm_image_border('<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], MEDIUM_IMAGE_WIDTH, MEDIUM_IMAGE_HEIGHT) . '</a>');

if (tep_get_products_special_price($listing['products_id'])) {
$r_price = '<s>' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</s>' . PRICE_SEPARATOR . '<span class="productSpecialPrice">' . $currencies->display_price(tep_get_products_special_price($listing['products_id']), tep_get_tax_rate($listing['products_tax_class_id'])) . '</span>';

} else {
$r_price = '<span class="productSpecialPrice">' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span>';
}

$r_desc =substr(strip_tags($product_listing_description['products_description']), 0, MAX_DESC_COL) . '...';

$r_view = '<a href="' . tep_href_link('product_info.php','products_id=' . $listing['products_id']) . '">' .tep_image_button('button_details.gif').'</a>';

$r_buy = '<a href="'.tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id']).'">' .tep_image_button('button_in_cart.gif').'</a>';





$num ++;

if ($num != 1) {
$colum++;
if ($colum > (COLUMN_COUNT-1)) {
$colum = 0;
$rows ++;
echo '</tr>

<tr>
<td align="right" colspan="12">
<br style="line-height:13px" />
<img src="'.DIR_WS_TEMPLATES . TEMPLATE_NAME.'/images/gl.gif" alt="" align="top" /><br /><br style="line-height:12px" />
</td>
</tr>

<tr>';

} else { echo '
<td style="background:url('.DIR_WS_TEMPLATES . TEMPLATE_NAME.'/images/vl.gif) repeat-y center top">
<table cellpadding="0" cellspacing="0" border="0" style="width:59px">
<tr>
<td style="height:30px; background:#FFFFFF">&nbsp;</td>
</tr>
</table>
</td>
';


$rc++;

}
}


echo tep_list_products_col ($r_pic, $r_name, $r_price, $r_desc, $r_view, $r_buy);


$column ++;
if ($column >= COLUMN_COUNT) {
$row ++;
$column = 0;
}
}



// new productListingBox($list_box_contents);
} else {
echo '<td>'.TEXT_NO_PRODUCTS.'</td>';

// new productListingBox($list_box_contents);
}


echo '
</tr>
<tr>
<td align="right" colspan="12">
<br style="line-height:13px" />
<img src="'.DIR_WS_TEMPLATES . TEMPLATE_NAME.'/images/gl.gif" alt="" align="top" /><br />
</td>
</tr>
</table>
</td>
</tr>
</table>
';


if ( ($listing_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3')) ) {
?>

<table width="100%" class="result">
<tr>
<td align="left" width="50%">
<?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?>
</td>
<td align="right" width="50%" class="result_right">
<?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?>
</td>
</tr>
</table>


</td></tr>
<?
}
?>





If any one can help please do:

The query is not in the code you are showing. You need to find that query, which I suspect is the $listing_sql could you

echo $listing_sql; and post here?

Hi thanks for the response but I decided to use a different template and it solved the problem