Php计数改变了多少= y其中humen = yes

Question

I tried something like this:

    $changed = mysql_query("SELECT * FROM games WHERE changed = 'y' AND human = '$_GET[human]' ORDER BY id DESC LIMIT 100", $link);
$num_rowsc = mysql_num_rows($changed); 

So what i want is to select last 100 where human = yes and count where changed = y ..

so get last 100 humans and count how many of them have on changed yes

Answer 1

Maybe with this query?

SELECT COUNT(*) AS cnt FROM (
    SELECT * FROM games 
    WHERE human = '".mysql_real_escape_string($_GET[human])."'
    ORDER BY id DESC LIMIT 100
) tmp WHERE changed = 'y'