计数多个值查询 - Count multiple values query

Count multiple values query

本文关键字：查询 | 更新日期: 2024-03-02

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

$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'];

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

这样尝试-

    $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_*函数已弃用，不建议使用它们。