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

Vuelvo a daros las gracias, respondeis muy rápido. Creo que he hecho lo que mes has dicho, pero sigo sin obtener resultados, pongo aquí una de las opciones que he utilizado en las pruebas, por si estoy cometiendo un fallo garrafal. Otra pregunta que tambien quería hacer es si no hay que modificar nada de esta línea:
while ($row=mysql_fetch_assoc($resultados)){


El codigo en estos momentos 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) {
?>
<?php

echo 'Cantidad';
echo 'Opcion';
/* uncomment if you want to show the model number echo TEXT_PRODUCT_MODEL; */
echo 'Precio';
?>
<?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']);
}


$contador =1;
$num_col=7;
echo "<tr>";
while ($row=mysql_fetch_assoc($resultados)){
echo "<td>";
echo tep_draw_input_field('quantity[]',$value = '0',"size=2");
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']);
echo $currencies->display_price($price_with_attribute, tep_get_tax_rate($product_info['products_tax_class_id']));

echo "</td>";
if ($contador == $num_col){
echo "</tr><tr>";
$contador=0;
}
$contador++;
}
//terminar de rellenar tablacon celdas...
if ($contador < $num_col){
$celdas_falt=$num_col - $contador;
while ($celdas_falt <= $num_col){
echo "<td>$nbsp</td>";
$celdas_falt++;
}
echo "</tr>";
}
$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;
}

/* ?>
<tr>
<td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td>
<td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td>
</tr>
<?php */
}
?>