Count multiple values query

Question

I want to use multiple queries to count multiple values and display those values in a table.

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

The echo above gives me no result. What am i doing wrong?

Suresh Kamrushi · Accepted Answer · 2013-12-10 13:51:56Z

1

Try like this-

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

Note: mysql_* functions are deprecated, using them not recommended.

answered Dec 10, 2013 at 13:51

Suresh Kamrushi

16.2k13 gold badges79 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Bart Friederichs Over a year ago

Using them is even discouraged.

Ryan Over a year ago

This won't work; my edit was declined for some reason, but you can't reference the field from $row1['gamer_count_nieuws'], you need to select it from the first row of the result. E.g. $row1[0]['gamer_count_nieuws']

Collectives™ on Stack Overflow

Count multiple values query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related