Product Listing at the bottom of the frontpage

[ArBoK]

I'm trying to put a general product listing at the bottom of the index.php (the default page part) so instead of the Featured Products box the costumer will see the general listing, all categories and manufacturers, i tried putting this code, wight below the Featured Products include:

 

            <td><?php //include(DIR_WS_MODULES . FILENAME_FEATURED); ?></td>
     <?php 
    	 $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id";
     ?>
   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
      <td><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td>
     </tr>
   </table></td>

 

As you see, i commented out the include for Featured Products, and put the other code down there, but all i get is a tiiny box at the bottom of the index that says "Displaying 1 to 1 (of 1 products) Result Pages: 1 ", no product picture or buy now button or price :o .

Anyone can give me a hand with this ?? :(

 

Thanks in advance :lol: