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
