List:General Discussion« Previous MessageNext Message »
From:Dane Harmon Date:February 12 2009 7:28pm
Subject:Re: How can avoid 2 selects and 2 while?
View as plain text  
I would do the following:
SELECT t1.features, t2.name, t2.size, t2.price
FROM table_2 as t2 LEFT JOIN table_1 as t1 ON t2.product_id = t1.product_id

Then in (psuedo) PHP:
$prev_features = "";
 foreach($result as $row){
  if ($row['features'] != $prev_features) {
echo ''Product features: " . $row[''features'] ;
$prev_features = $row['features'];
}
echo $row info...
}


DH


On Thu, Feb 12, 2009 at 10:43 AM, Jose Julian Buda <
jbuda@stripped> wrote:

> table_1:
> product_id      features  .....
> 1                        aaa
> 2                        bbb
> 3                        ccc
>
> table_2 :
> product_id    name   size    price
> 1                     11        1          111
> 1                     12       2         221
> 1                     13        3         331
> 2                      21       1         112
> 2                      22       2        222
> 3                      31      1        113
> 3                      32       2        223
> 3                      33      3        333
>
>
> What i want is the next report for example the size =2
> .............
> Report of products with size =2
>
> Product features : aaa
> Name   12    Price 221
>
> Product features : bbb
> Name 22     Price  222
>
> Product features : ccc
> Name 32     Price  223
> ...........
>
>
> basically what i do now with php is :
> ...
> $cliente=mysql_query("select * from table_1");
> while($row = mysql_fetch_array($cliente))
> {
>    printf("\nProduct features  : %s\n",$row[features]);
>    $cliente2=mysql_query("select name,price from table_2 where
> product_id='$row[product_id]' and size=2");
>    while($row2 = mysql_fetch_array($cliente2))
>    {
>  .     print("Name %s --- Price %s\n",$row2[name],$row2[price],);
>    }
> }
> .........
>
> How can i do this without 2 select and whitout 2 while and the "features"
> be printed just one time?
>
>
> Thank you in advance
>
> Jose Julian Buda

Thread
How can avoid 2 selects and 2 while?Jose Julian Buda12 Feb
  • Re: How can avoid 2 selects and 2 while? SOLVEDJose Julian Buda12 Feb
    • RE: How can avoid 2 selects and 2 while? SOLVEDMartin Gainty12 Feb
  • Re: How can avoid 2 selects and 2 while?Dane Harmon12 Feb