How to Catch Results inside the loop and grouping into a variable outside it

Question

How to Catch Results inside the loop and grouping into a variable outside it

Asked 7 years, 10 months ago

Viewed 1,000 times

1

How to Catch Results inside the loop and grouping into a variable outside it Example:

$sql55 = "SELECT * FROM finan WHERE MONTH(data_fechamento)= '02' ";
$resultado55 = mysql_query($sql55) or die( mysql_error());
while ($row55 = mysql_fetch_assoc($resultado55)) {
echo '<br>';
echo $vencimento2 =  $row55['vencimento'];
//  retorno echo  2017-02-02
                  2017-02-04
                  2017-02-05
                  2017-02-03
}

// queria pegar esse mesmo daros em uma variaval fora do while
echo $juntandoresultados; // exmplo

//////////////////////////////////////////////////////////////////////

2 answers

Browser other questions tagged php

You are not signed in. Login or sign up in order to post.

by user60252 · Answer 1 · 2017-01-25T22:13:28+00:00

2

$sql55 = "SELECT * FROM finan WHERE MONTH(data_fechamento)= '02' ";
$resultado55 = mysql_query($sql55) or die( mysql_error());
$juntandoresultados="";
while ($row55 = mysql_fetch_assoc($resultado55)) {

$juntandoresultados .= "<br>".$row55['vencimento'];

}
echo $juntandoresultados;

For your answer to be perfect is only missing put $joining results=""; before the while. 'Cause the way it is, spending the first time in the while will make an error that the variable $joining results does not exist.

– Antonio Alexandre

2017/01/25 at 23:25
1

beauty, I’ve already put

– user60252

2017/01/26 at 00:09
Mark the answer as chosen :)

– user60252

2017/01/28 at 19:31

by Jonas Ferreira • **104** points · Answer 2 · 2017-01-25T22:58:27+00:00

Saving inside an array would help?

$dados = array();

$sql55 = "SELECT * FROM finan WHERE MONTH(data_fechamento)= '02' ";
$resultado55 = mysql_query($sql55) or die( mysql_error());
while ($row55 = mysql_fetch_assoc($resultado55)) {
  array_push($dados,$row55['vencimento']);
}

print_r($dados);

----------------------or so ------

$dados = "";

$sql55 = "SELECT * FROM finan WHERE MONTH(data_fechamento)= '02' ";
$resultado55 = mysql_query($sql55) or die( mysql_error());
while ($row55 = mysql_fetch_assoc($resultado55)) {
  $dados .= $row55['vencimento']." ";
}

echo $dados ;