php - 无法使用 PHP 打印 MySQL 查询结果

Question

我有以下 MySQL 查询

$jokerQuery = mysql_query("SELECT `Joker sport`,
        COUNT(`Joker sport`) AS jokerCount
        FROM Profiles
        WHERE `CompetitorID` = 5
        GROUP BY `Joker sport`
        ORDER BY COUNT(`Joker sport`) DESC
        LIMIT 1
    ");

在 phpMyAdmin 中返回以下结果

Joker sport | jokerCount
8           | 8

我以为下面的 php 会显示结果，但它不起作用。我应该写什么来回显结果？

$jokerResult = mysql_fetch_array($jokerQuery);
echo $jokerResult['Joker sport'];
echo $jokerResult['jokerCount'];

Answer 1

试试这个，添加MYSQL_ASSOC作为mysql_fetch_array中的const :

$jokerResult = mysql_fetch_array($jokerQuery, MYSQL_ASSOC);
echo $jokerResult['Joker sport'];
echo $jokerResult['jokerCount'];