Loop question and num_rows

[karimali831]

Hi,

 

Can someone tell me if query2 will select all rows where ALL cupID has 1 in the 1on1 column at query 1?

Secondly, it is not outputting mysql_num_rows correctly from both queries.

It does count right however without cupID='".$row['ID']."'.  ?

 

 

$query1 = mysql_query("SELECT ID FROM table1 WHERE 1on1='1'");
while($row=mysql_fetch_array($query1)) {

if(this equals that) {

$query2 = mysql_query("SELECT * FROM table2 WHERE cupID='".$row['ID']."' AND clan1='$id' AND score1 > score2");
$num = mysql_num_rows($query2);

}else

$query3 = mysql_query("SELECT * FROM table2 WHERE cupID='".$row['ID']."' AND clan2='$id' score2 > score1");
$num2 = mysql_num_rows($query3);

}

$total = $num+$num2;

}

 

Thanks for help

[karimali831]

Also, I know I missed out AND in query3 but that's not the issue.

[karimali831]

help please? 

[karimali831]

[MatthewJ]

Maybe try to rephrase the question...