How to reduce the number of requests?

Question

Good all the time of day.

$result = mysql_query("SELECT COUNT(*), sum(q), sum(w), sum(e), sum(r) FROM zakaz WHERE d<'$d' AND c>'$c' AND a='$a' AND z='01'",$db);

I have "many" such requests, with a difference only in z = 01, 02, 03, .... 99. Is it possible to somehow reduce the number of requests?

PS Ie do not write this into a cycle, which is shorter, but reduce the number of requests.

Accepted Answer · 2011-09-16T13:38:18

The easiest:

 $result = mysql_query("SELECT COUNT(*), sum(q), sum(w), sum(e), sum(r) FROM zakaz WHERE d<'$d' AND c>'$c' AND a='$a' AND z IN ('01','02','03')",$db); //в скобках узказываем все необходимые значения для z

Added by:

  //имеем массив $z = array('01','02','03'); //инициализируем массивчик куда будем складировать вывод. $out = array(); //формируем строку запроса: $query = "SELECT COUNT(*), sum(q) as sum_q, sum(w) as sum_w, sum(e) as sum_e, sum(r) as sum_r FROM zakaz WHERE d<'$d' AND c>'$c' AND a='$a' AND z IN ('".implode("','",$z)."') GROUP BY z"; //обращаемся к базе $result = mysql_query($query,$db); while ($row=mysql_fetch_assoc($result)) { //выводим результат: echo $row['sum_q']; //записываем в выходной массив целиком строку $out[] = $row; //либо какое то одно значение $out[] = $row['sum_q']; }

After the request, I want to get the results of the request.
Since I do not know how to make a request, and asked about it, it was possible to guess that getting the result of the query more complicated would also be problematic for me (logical conclusions of the CEP).
The result of the query is obtained in the same way, and there is no direct connection with the complexity of the query.
I learned a lot of new things, more understandable, but not completely.
This is what I wrote with the top 495 variables (95 sums of quantity and 380 sums of values), well, by WISH, I can "echo" them.
... for some values (say 03, 04 ...) gives the correct amount, for which the amount is not correct.

Nicolas Chabanovsky ♦ 38.2k 54 221 438 · Answer 2 · 2011-09-16T13:18:29

 $result = mysql_query("SELECT COUNT(*), sum(q), sum(w), sum(e), sum(r), z FROM zakaz WHERE d<'$d' AND c>'$c' AND a='$a' GROUP BY z",$db);

Now the query will not be executed in a loop, this loop will be used when reading the results. If you need to somehow limit the field z, then use the condition, say "z BETWEEN '01' AND '99'"

after my installation, I had: $ myrow = mysql_fetch_array ($ result);
Array ([0] => 0 [COUNT (*)] => 0 [1] => [sum (q)] => [2] => [sum (w)] => [3] => [sum (e)] => [4] => [sum (r)] =>) prescribed, it still did not reach.

How to reduce the number of requests?

2 answers 2

More articles: