There is a page of this kind: enter image description here

On it from the base are drawn the number of works in this way:

<table> <tr> <td><p class="array">Наименование субъекта Российской Федерации</p></td> <td><p class="array">Количество работ</p></td> </tr> <?php include 'bd.php'; $result = mysql_query("SELECT region, count(region) FROM `register_user` GROUP BY `region`"); $array = mysql_fetch_array($result); do { echo ""."<tr><td><p class='array'>".$array[region]."</p></td><td><p class='array'><a>".$array[count(region)]."</a></p></td></tr>".""; } while ($array = mysql_fetch_array($result)); ?> </table>

How to make numbers in number of works links to other pages? They must be different for their region.

That is, by clicking on the number of works, we will receive information on work in the relevant region.

    1 answer 1

    you did not specify a required attribute for the href link

    • That is, you need to specify a link for each region? - user234223
    • yes <a href="/link to region/.$array['region'06."> ". $ array [count (region)]." </a> - Kdes70
    • This is hardly suitable for me ... Since the table is filled by itself in accordance with the regions, if a new job is added, a new region is added ... - user234223
    • Perhaps you know some alternative solution? In the final click, let's say on baikonur, we need to get this page: imgur.com/a/iA4ta With a sample of only the relevant region. - user234223
    • in your case, you need to create a page where you will receive from the address straki of the prorameter, - Kdes70