php - 统计多值查询

Question

我想使用多个查询来计算多个值并将这些值显示在表格中。

$resultnieuws = mysql_query("select gamer_int, count(gamer_int) as gamer_count_nieuws     FROM berichten WHERE gamer_int LIKE 'Kenny' AND soort LIKE 'nieuws'");
$resultvideo = mysql_query("select gamer_int, count(gamer_int) as gamer_count_video FROM berichten WHERE gamer_int LIKE 'Kenny' AND soort LIKE 'video'");

echo $resultnieuws['gamer_count_nieuws'];
echo $resultvideo['gamer_count_video'];

上面的 echo 没有给我任何结果。我做错了什么？

Answer 1

尝试这样-

    $resultnieuws = mysql_query("select gamer_int, count(gamer_int) as gamer_count_nieuws     FROM berichten WHERE gamer_int LIKE 'Kenny' AND soort LIKE 'nieuws'");
    $resultvideo = mysql_query("select gamer_int, count(gamer_int) as gamer_count_video FROM berichten WHERE gamer_int LIKE 'Kenny' AND soort LIKE 'video'");

    $row1 = mysql_fetch_array($resultnieuws);
    $row2 = mysql_fetch_array($resultvideo);

    echo $row1['gamer_count_nieuws'];
    echo $row2['gamer_count_video'];

注意:mysql_* 函数已弃用，不建议使用它们。