php - Mysql 选择不同的 ID 和名称

Question

我有一个包含一些字段的 MySQL 表。 2 个字段有问题。

字段是包含唯一数字的official_country_name_sort_field和包含名称的字段“official_country_name”。

我想选择唯一的 official_country_name_sort_field 并在 GET 方法中使用它，但在网站上我想显示 official_country_name 中的名称。

我有这个函数可以显示来自official_country_name_sort_field的ID:

$sql = "select distinct official_country_name_sort_field as name from t_container,t_country where  (t_container.country_id = t_country.id) and (t_container.category = '$category') and (t_country.slug = '$slug') order by t_container.official_country_name_sort_field";

   $result = mysqli_query($link,$sql);
   if (!$result) {
         $output = 'Error fetching official country names : '.mysqli_error($link);
         include   '../templates/db/error.html.php';
         exit();
    }
    $officialCountryNames = array();
    while ($row= mysqli_fetch_array($result)) {
         $officialCountryNames []  = $row['name'];

    }

    return $officialCountryNames;

}

<?php foreach ($officialCountryNames as $officialCountryName ) : ?>
      <h3>  <a href="<?php echo "../currencylist?showall&country=$slug&category=$category&official_name=$officialCountryName"; ?>  "><?php  echo "$officialCountryName"; ?></a></h3>
      

      <?php endforeach  ?>

在这个节目中，我有“officialCountryName”- ID(来自表列“official_country_name_sort_field”的数字。如何显示表列“official_country_name”中的名称而不是“official_country_name_sort_field”中的 ID。

Answer 1

    $sql = "select distinct official_country_name_sort_field as code, official_country_name as name from t_container,t_country where  (t_container.country_id = t_country.id) and (t_container.category = '$category') and (t_country.slug = '$slug') order by t_container.official_country_name_sort_field";

   $result = mysqli_query($link,$sql);
   if (!$result) {
         $output = 'Error fetching official country names : '.mysqli_error($link);
         include   '../templates/db/error.html.php';
         exit();
    }
    $officialCountryNames = array();
    while ($row= mysqli_fetch_array($result)) {
         $officialCountryNames[]['name']  = $row['name'];
         $officialCountryNames[]['code']  = $row['name'];    
    }

    return $officialCountryNames;

}

使用上面的查询并在 while 循环中进行更改。