Help combinding 2 mysql queries

[rootnik]

The first query is the most important one. I'm only using the 2nd query to get a count...

PHP Code:

SELECT u.username, u.lastactivity, f.field5, f.field14, f.field15, f.field16, f.field17, f.field19, f.userid
FROM user u
INNER JOIN userfield f
ON u.userid=f.userid
WHERE f.field16 = 'Yes' AND f.field19 > 0
ORDER BY u.lastactivity DESC; 


Now I want to get a count of all members who has field19 set as greater than 0. It does not what the value of field16 is in the query below:

PHP Code:

$ingame = mysql_result($TheTopQuery, 0, 7);
$custom = $db->query_read("
SELECT field19 FROM userfield
WHERE userfield.field19 = $ingame
ORDER BY userid DESC;
        "); 


[Andrew]

I think you need to move the variable $ingame from the second query out of the double quotes like so:

PHP Code:

$ingame = mysql_result($TheTopQuery, 0, 7);
$custom = $db->query_read("
    SELECT field19
    FROM userfield
    WHERE userfield.field19 = " . $ingame . "
    ORDER BY userid DESC
"); 


[rootnik]

Originally Posted by Andrew

I think you need to move the variable $ingame from the second query out of the double quotes like so:

PHP Code:

$ingame = mysql_result($TheTopQuery, 0, 7);
$custom = $db->query_read("
    SELECT field19
    FROM userfield
    WHERE userfield.field19 = " . $ingame . "
    ORDER BY userid DESC
"); 


Thanks... but somehow the query works as needed without the double quotes.

Both queries work, I am just looking to combind then into 1 query.

Is it even possible considering that the value for $ingame comes from the first query?

[Xenon]

first of all
the doublequoete are irrelevant in that context

second: i don't really get the sense of the second query, you say you want to count member with the same valuie of field 19, but there is no count function in the query, so?

are you running the second query within a loop or what?
because soley combining a normal and a count query isn't possible, but if you tell us a bit more, maybe an optimization would be possible