grouping two queries / join query?

[karimali831]

I am using two seperate queries to calculate a streak, but the queries must be grouped together to find the actual streak?

 

Query 1:

 

SELECT COUNT(matchID) as streak, clan1 FROM webs_cup_matches WHERE ladID='17' AND clan1='2630' AND score1 > score2 AND confirmscore='1' AND einspruch='0' GROUP BY clan1 ORDER BY streak DESC LIMIT 1

Query 2:

SELECT COUNT(matchID) as streak, clan2 FROM webs_cup_matches WHERE ladID='17' AND clan2='2630' AND score1 < score2 AND confirmscore='1' AND einspruch='0' GROUP BY clan2 ORDER BY streak DESC LIMIT 1

 

is it possible someone can join these queries together?

[sweeb]

http://dev.mysql.com/doc/refman/5.0/en/union.html

 

[karimali831]

I had an attempt at this but wasn't successful could you do this for me please?

[karimali831]

Is this correct ? I hope

 

$query = 

"SELECT COUNT(matchID) as streak, clan1 FROM webs_cup_matches WHERE ladID='$laddID' AND clan1='$teamID' AND score1 > score2 AND confirmscore='1' AND einspruch='0' GROUP BY clan1 DESC LIMIT 1
    UNION
SELECT COUNT(matchID) as streak, clan2 FROM webs_cup_matches WHERE ladID='$laddID' AND clan2='$teamID' AND score1 < score2 AND confirmscore='1' AND einspruch='0' GROUP BY clan2 ORDER BY streak DESC LIMIT 1";


   $streak = mysql_query($query);

[sweeb]

Looks good to me