karimali831 Posted July 22, 2010 Share Posted July 22, 2010 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 Link to comment https://forums.phpfreaks.com/topic/208544-loop-question-and-num_rows/ Share on other sites More sharing options...
karimali831 Posted July 22, 2010 Author Share Posted July 22, 2010 Also, I know I missed out AND in query3 but that's not the issue. Link to comment https://forums.phpfreaks.com/topic/208544-loop-question-and-num_rows/#findComment-1089610 Share on other sites More sharing options...
karimali831 Posted July 22, 2010 Author Share Posted July 22, 2010 help please? Link to comment https://forums.phpfreaks.com/topic/208544-loop-question-and-num_rows/#findComment-1089651 Share on other sites More sharing options...
karimali831 Posted July 22, 2010 Author Share Posted July 22, 2010 Link to comment https://forums.phpfreaks.com/topic/208544-loop-question-and-num_rows/#findComment-1089712 Share on other sites More sharing options...
MatthewJ Posted July 22, 2010 Share Posted July 22, 2010 Maybe try to rephrase the question... Link to comment https://forums.phpfreaks.com/topic/208544-loop-question-and-num_rows/#findComment-1089714 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.