how to expand the categories in home page

[soibaal]

Dear sir

In the home page I wish to have the products diplayed by default under the various categories

category one
product 1
product 2

how can i do. is there a contribution. i cannot locate it.

thanks a million.

ashok

[soibaal]

Dear friends

i found this in oscommerce contributions. This creates a drop down of products in the home page.

a) Just save it in as products_drop.php and upload to catalog/includes/boxes.

<?php
/*
osCommerce, Open Source E-Commerce Solutions
osCommerce, Open Source Online Shop E-Commerce Solutions

Copyright (c) 2001 osCommerce

Released under the GNU General Public License
*/
?>
<tr>
<td>
<?php
new infoBox($info_box_contents, false, false);

$products_query = tep_db_query("select p.products_id, pd.products_name, c.categories_id, cd.categories_name, p2c.categories_id, p2c.products_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and c.categories_id = cd.categories_id and p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and pd.language_id = '" . (int)$languages_id . "' and cd.language_id = '" . (int)$languages_id . "' order by pd.products_name");
if ($number_of_rows = tep_db_num_rows($products_query)) {

$products_array = array();
$products_array[] = array('id' => '', 'text' => 'Select Product');

while ($products = tep_db_fetch_array($products_query)) {
$products_name = $products['products_name'] . '&nbsp;-&nbsp;' . $products['categories_name'];
$products_array[] = array('id' => $products['products_id'],
'text' => $products_name);
}

$info_box_contents = array();
$info_box_contents[] = array('form' => tep_draw_form('products', tep_href_link(FILENAME_PRODUCT_INFO, '', 'NONSSL', false), 'get'),
'text' => tep_draw_pull_down_menu('products_id', $products_array, (isset($HTTP_GET_VARS['products_id']) ? $HTTP_GET_VARS['products_id'] : ''), 'onChange="this.form.submit();" size="' . MAX_PRODUCTS_LIST . '" style="width: 200"') . tep_hide_session_id());


new infoBox($info_box_contents);
}
?>
</td>
</tr>


b) write a code in catalog/includes/column_left.php or in catalog/includes/column_right.php
before ?> or a anywhere between <?php ---- ?>
include(DIR_WS_BOXES . 'products_drop.php');

---------------------------------------------------------------

My requirement is not a drop down but a list of products.
how do i achieve it.

regards
ashok