[sql] o [php] prodotti per categoria

[punkrazio]

ecco scusa il mio ritardo


queste sono le tabelle che uso:

CATEGORIA

id  	
categoria

PRODCAT

idprod
idcat

PRODOTTI

id  	
Nome 	
Descrizione 	
Seconda_descrizione
Input_power
Housing_material
Motor_power
Scution_capacity
Air_Flow
Recovery_dirty_tank_capacity
Filtration_system
Boiler_capacity
Boiler_material
Boiler_power
Iron_power
Max_steam_pressure
Max_steam_temperature
Refilling_water_tank_capacity_auto_refilling_system
Water_refilling_pump_power
Detergent_tank_capacity 
Detergent_injection_pump
Electric_Power_cord_lenght
Flexible_hose_with_handle_grip_lenght
Commands
Main_unit_dimensions
Main_unit_weight
Packaging_dimensions
Number_of_units_per_pallet
Features
anteprima

PRODKIND

idprod
idtipo

TIPO_PROD

id
tipo_prod

questa è invece la funzione che uso per generare i prodotti per ogni categoria

function generate_product_per_category($idcat, $page)
{
  /* set pagination variables */
  $display = 5;
  $pg = (isset($_REQUEST['pg']) && ctype_digit($_REQUEST['pg'])) ?  $_REQUEST['pg'] : 1;
                                                                              
  $start = $display * $pg - $display;
  /* paginating from a database */
  $result = mysql_query("SELECT count(*) FROM prodcat WHERE idcat = $idcat");
  $total = mysql_result($result, 0);
        
  $qproduct = "SELECT p.anteprima, p.Nome, p.Max_steam_pressure, tp.tipo_prod, p.Boiler_capacity, p.Detergent_tank_capacity, p.Refilling_water_tank_capacity_auto_refilling_system, p.id
                FROM prodotti AS p, categoria AS c, prodcat AS pc, prodkind AS pk, tipo_prod AS tp
                 WHERE p.id = pc.idprod
                   AND p.id = pk.idprod
                   AND pc.idcat = c.id
                   AND pk.idtipo = tp.id
                   AND c.id = $idcat 
                   LIMIT $start, $display";
   
  $qproductsexe = mysql_query($qproduct) or die("Errore Home Message: " . mysql_error());
      
  while( $row = @mysql_fetch_assoc($qproductsexe) ) 
  {    
    $product_list .= implode("",file($template_dir."product_list.tpl"));
    $product_list = eregi_replace("", $row['anteprima'], $product_list);
    $product_list = eregi_replace("", $row['Nome'], $product_list);
    $product_list = eregi_replace("", $row['Max_steam_pressure'], $product_list);
    $caratteristiche = "";
    if( $row['Boiler_capacity']!='' )
    {
      $caratteristiche .= "Boiler Capacity: ".$row['Boiler_capacity']."
";
    }
    /*if( $row['Detergent_tank_capacity']!='' )
    {
      $caratteristiche .= "Chemical Tank: ".$row['Detergent_tank_capacity']."
";
    }
    if( $row['Refilling_water_tank_capacity_auto_refilling_system']!='' )
    {
      $caratteristiche .= "Auto Refill Tank: ".$row['Refilling_water_tank_capacity_auto_refilling_system'];
    }*/
    $product_list = eregi_replace("", $caratteristiche, $product_list);
    $product_list = eregi_replace("", $row['tipo_prod'], $product_list);
    $product_list = eregi_replace("", $row['id'], $product_list);
                    
  }
       
  $pagina = paginate($display, $pg, $total);
  //$product_list = eregi_replace("", $pagina, $product_list);
  $product_list .= $pagina;
  return $product_list;
}//end generate product per category 

spero ti possa servire per aiutarmi
ciauz e grazie