sto impazzendo, non riesco assolutamente a venrine a capo! allora il codice è questo:
while ($bundle_data = tep_db_fetch_array($bundle_query)) {
if ($bundle_data['products_bundle'] == "yes") {
echo "
» " . $bundle_data['subproduct_qty'] . " x " . $bundle_data['products_name'] . "";
echo "
» " . $bundle_data['products_name'] . "";
$bundle_query_nested = tep_db_query("SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, p.products_price FROM products p INNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON p.products_id=pd.products_id INNER JOIN " . TABLE_PRODUCTS_BUNDLES . " pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id = " . $bundle_data['products_id'] . " and language_id = '" . (int)$languages_id . "'");
while ($bundle_data_nested = tep_db_fetch_array($bundle_query_nested)) {
echo "
" . $bundle_data_nested['subproduct_qty'] . " x " . $bundle_data_nested['products_name'] . "";
echo "
" . $bundle_data_nested['products_name'] . "";
$bundle_sum += $bundle_data_nested['products_price']*$bundle_data_nested['subproduct_qty'];
}
} else {
echo "<tr><td class=main valign=top>" ;
echo '' . tep_image(DIR_WS_IMAGES . $bundle_data['products_image'], $bundle_data['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="1" vspace="1"') . '' ;
echo "</td><td class=main >&raquo; " . $bundle_data['subproduct_qty'] . " x " . $bundle_data['products_name'] . '</td><td align = right class=main>' . $currencies->display_price($bundle_data['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . "</td></tr>";
$bundle_sum += $bundle_data['products_price']*$bundle_data['subproduct_qty'];
}
}



e la query è questa...
$bundle_query = tep_db_query(" SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, p.products_price, p.products_image FROM products p INNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON p.products_id=pd.products_id INNER JOIN " . TABLE_PRODUCTS_BUNDLES . " pb ON pb.subproduct_id=pd.products_id WHERE pb.referredto_id = " . $HTTP_GET_VARS['products_id'] . " and language_id = '" . (int)$languages_id . "'");


e la tabella quella che ho riportato nel primo intervento. Devo fare in modo che tutti i record con bundle_id uguale (ad esempio x) vengano inseriti nella stessa <table> in html, che quindi poi questa venga chiusa </table> e che se ne apra una nuova (con ad esempio i bundle_id uguali a y) e via dicendo...