List:General Discussion« Previous MessageNext Message »
From:Jose Julian Buda Date:February 12 2009 3:43pm
Subject:How can avoid 2 selects and 2 while?
View as plain text  
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