Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product List on index page


NanoSys

Recommended Posts

Posted

Guys-

 

 

I would like to print the product list on the index page.

 

I was going to hard code it myself but I think there is a module that does it for you.

 

I tried:

<?php
 } else { // default page
?>
   <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">
         <tr>
           <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
           <td class="pageHeading" align="right"><?php //echo tep_image(DIR_WS_IMAGES . 'table_background_default.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
         </tr>
       </table></td>
     </tr>
     <tr>
       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
     </tr>
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
         <tr>
           <td class="main"><?php echo tep_customer_greeting(); ?></td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
         <tr>
           <td class="main"><?php echo TEXT_MAIN; ?></td>
         </tr>
         <tr>
           <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
         </tr>
         <tr>
           <td><?php //include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS);
	 include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING);  //include the product listing on the default page?></td>
         </tr>

 

 

However I get an error message, it says:

1109 - Unknown table 'p' in field list

 

select count(p.products_id) as total

 

[TEP STOP]

 

I dont understand,

 

Thanks,

Jonathen Scalet

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...