- $master = "SELECT * FROM master ORDER BY id";
- $master_query = mysql_query("$master");
- while ($master_select = mysql_fetch_assoc($master_query))
- {
- echo $master_select['name'];
- $summa = "SELECT * FROM visit WHERE date= '".$day."' AND id_master= '".$master_select['id']."'";
- $summa_query = mysql_query("$summa ");
- while ($summa_select = mysql_fetch_assoc($summa_query))
- {
- $s += $summa_select['summa'];
- echo $s;
- }
- }
- }