Редакция 4 | Весь файл | Не учитывать пробелы | Содержимое файла | Авторство | Последнее изменение | Открыть журнал | RSS
Редакция 4 | Редакция 5 | ||
---|---|---|---|
Строка 11... | Строка 11... | ||
11 | echo "<tr>"; |
11 | echo "<tr>"; |
12 | echo "<th>Ник</th><th>Аватар</th><th>Контакты</th><th>Ресурсы</th>"; |
12 | echo "<th>Ник</th><th>Аватар</th><th>Контакты</th><th>Ресурсы</th>"; |
13 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
13 | while ($mems->fetchInto($info_mems, DB_FETCHMODE_ASSOC)) { |
14 | $ranks =& $db->query("SELECT * |
14 | $ranks =& $db->query("SELECT * |
15 | FROM res_mem_rank
|
15 | FROM res_mem_rank
|
16 | JOIN res_net_stat ON res_mem_rank.res_net_id = res_net_stat.id
|
16 | JOIN resources ON resources.id = res_mem_rank.resource_id
|
17 | JOIN networks ON networks.id = res_net_stat.network_id
|
17 | JOIN networks ON networks.id = res_mem_rank.network_id
|
18 | JOIN resources ON resources.id = res_net_stat.resource_id
|
18 | JOIN members ON members.id = res_mem_rank.member_id
|
19 | WHERE member_id=".$info_mems['id']); |
19 | WHERE member_id=".$info_mems['id']); |
20 | $ranklist = ""; |
20 | $ranklist = ""; |
21 | while ($ranks->fetchInto($info_ranks, DB_FETCHMODE_ASSOC)) { |
21 | while ($ranks->fetchInto($info_ranks, DB_FETCHMODE_ASSOC)) { |
22 | $ranklist .= $info_ranks['resource']." ".$info_ranks['network']."<br>"; |
22 | $ranklist .= $info_ranks['resource']." ".$info_ranks['network']."<br>"; |
23 | }
|
23 | }
|