Product Listing Module is not Working

[mudgil.gaurav]

Hi All

 

I am new to OsCommerce , i want to use the product listing module on my home page and for the same i am doing

 

<td colspan="5" align="left" valign="top"><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td>

 

But this module raises and error like

 

1109 - Unknown table 'p' in field list

 

select count(p.products_id) as total

 

[TEP STOP]

 

 

But when i use new products module like

 

<td colspan="5" align="left" valign="top"><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td>

 

then it works fine with the product table.

 

I really need to get the rid of this issue as soon as possible.

 

Any help would be greatly appriciated

 

Thanks

Gaurav