Mysql-a php computing result problem. Please be a master

{Code ...}

// Search for $ SQL = "select * from part_time where agents = 6"; $ result = mysql_query ($ SQL ); while ($ row = mysql_fetch_assoc ($ result) {$ id = $ row ['id']; // cyclically generate all agents = 2 IDs $ resu = "select count (*) from userinfo where part_person = $ id"; $ re = mysql_query ($ resu ); $ roo = mysql_fetch_assoc ($ re); $ number = $ roo ['count (*) ']; // calculates that userinfo is the same part-time employee (part_time) echo $ number; echo "----" ;}// add $ number to get the final number. What should I do? Please answer

Reply content:

// Search for $ SQL = "select * from part_time where agents = 6"; $ result = mysql_query ($ SQL ); while ($ row = mysql_fetch_assoc ($ result) {$ id = $ row ['id']; // cyclically generate all agents = 2 IDs $ resu = "select count (*) from userinfo where part_person = $ id"; $ re = mysql_query ($ resu ); $ roo = mysql_fetch_assoc ($ re); $ number = $ roo ['count (*) ']; // calculates that userinfo is the same part-time employee (part_time) echo $ number; echo "----" ;}// add $ number to get the final number. What should I do? Please answer

InwhileThe preceding definition is as follows:$numberAnd then directly$number+=$row['count(*)']You can.

In addition, I simplified the code for you...

$sql = 'select count(*) as total from userinfo where part_person IN (select id from part_time where agents = 6)';$result = mysql_query($sql);$row = mysql_fetch_assoc($result);echo $row['total'];

Defines $ sum = 0;
Add $ sum + = $ number to while

$ Number + = $ roo ['count (*) '];

Wow, when you repeatedly call the database in a loop statement, it is estimated that the database will not be able to withstand the high traffic volume. You can use join queries.

Try aggregate.

$number += $roo['count(*)'];

But this code is a bit ..