Ver Mensaje Individual
  #18 (permalink)  
Antiguo 17/11/2010, 04:32
ville_cdo
 
Fecha de Ingreso: noviembre-2010
Mensajes: 4
Antigüedad: 13 años, 6 meses
Puntos: 0
Respuesta: tablas y while problemas...

Gracias por responder tan rápido, he estado intentándolo y no sé exactamente donde insertarlo, y tampoco sé si me he explicado bien. Porque el A1,A2,A3 están relacionados entre sí, es como si dentro de una celda pusiese un número, imagen y texto.

El Código completo es este:

<?php
$products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");
$products_attributes = tep_db_fetch_array($products_attributes_query);
if ($products_attributes['total'] > 0) {
?>
<table border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main" align="center"><?php echo 'Cantidad'; ?></td>
<td class="main" align="center"><?php echo 'Opcion'; ?></td>
<td class="main" align="center"><?php /* uncomment if you want to show the model number echo TEXT_PRODUCT_MODEL; */ ?></td>
<td class="main" align="center"><?php echo 'Precio'; ?></td>

</tr>
<?php
$X=0;

$products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");
while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {
$products_options_array = array();
$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");

while ($products_options = tep_db_fetch_array($products_options_query)) {
$products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);
if ($products_options['options_values_price'] != '0') {
$products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';
if ($products_options['price_prefix'] == '+') {
$price_with_attribute = ($product_info['products_price'] + $products_options['options_values_price']);
} else {
$price_with_attribute = ($product_info['products_price'] - $products_options['options_values_price']);
}
?>
<tr>
<td class="main" align="center"><?php echo tep_draw_input_field('quantity[]',$value = '0',"size=2");?></td>
<td class="main" align="center">
<?php echo $products_options['products_options_values_name'];
echo tep_draw_hidden_field('a[]', $products_options['products_options_values_id']);
echo tep_draw_hidden_field('b[]',$products_options_name['products_options_id']); ?> </td>
<td class="main" align="center">
<?php /* uncomment if you want to show the model number
echo $product_info['products_model']; */
?>
</td>
<td class="main" align="center"><?php echo $currencies->display_price($price_with_attribute, tep_get_tax_rate($product_info['products_tax_class_id'])); ?></td>
</tr>
<?php
$x++;
}
}

if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {
$selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];
} else {
$selected_attribute = false;
}
}
?>
</table>