MYSQL不会从数据库(php）返回DISTINCT VALUE

MYSQL is not returning DISTINCT values from database (php)

本文关键字：返回 DISTINCT VALUE php 数据库 MYSQL | 更新日期: 2023-09-27

我使用以下代码从我的数据库中返回不同的 Raceid

$distinctraceid = mysqli_query($db, 'SELECT DISTINCT `raceid` FROM tom_cards ORDER BY raceid');
while ($distinctraceid2  = mysqli_fetch_array($distinctraceid)) {
     echo $distinctraceid2['raceid']."<br />";
}

输出虽然显示所有 ID？

621441 621441 621442 621441 621442 621443 621441 621442 621443 621444 621441

ID int(255) NO PRI NULL auto_increment
raceid int(11) NO NULL
Date varchar(250) YES NULL
Racetime varchar(25) NO NULL

SELECT DISTINCT tc.`raceid` FROM tom_cards AS tc ORDER BY tc.raceid ASC