How do I put a select inside the while?

Question

Sublime text, Mysql Workbench and Xampp usage.

I made a Join Inner in select below, in a table called Organizations.Copia. In this table there is a field called "id" and I need it to appear in this Php code.

I saw several videos and examples, and could not do. How I put to pull the copy of these returning customers in my variable "$result"? How do I include that in while?

Follow the code ready:

<?php

$servidor = '****';
$user = '****';
$senha = '****';
$banco = 'Organizacoes';

// Cria conexão
$conn = new mysqli($servidor, $user, $senha, $banco);
// Checa conexão
if ($conn->connect_error) {
    die("Conexão falha: " . $conn->connect_error);
} 

$sql = "SELECT   Org.id
        ,Org.nome 
        FROM Organizacoes as Org 

        INNER JOIN Organizacoes.Rel_Organizacoes as Grupo on Org.id = Grupo.id_Organizacao
        INNER JOIN Organizacoes.Copias as Copia on Org.id = Copia.id_Organizacao

        WHERE  Grupo.id_grupo = 210 
        GROUP BY Org.id
        ORDER BY Org.id";

$result = $conn->query($sql);

echo " <tr>";


if ($result->num_rows > 0) {
    // dados de saída de cada linha
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - nome: " . $row["nome"]. " " . "<br>";
    }

} else {
    echo "0 results";
}
$conn->close();

?>

Answer 1

Good morning, you could use this solution. I don’t know if php would be correct, but in the query can be this solution.

<?php

$servidor = '****';
$user = '****';
$senha = '****';
$banco = 'Organizacoes';

// Cria conexão
$conn = new mysqli($servidor, $user, $senha, $banco);
// Checa conexão
if ($conn->connect_error) {
    die("Conexão falha: " . $conn->connect_error);
} 

$sql = "SELECT Copia.*,  Org.id
    ,Org.nome 
    FROM Organizacoes as Org 

    INNER JOIN Organizacoes.Rel_Organizacoes as Grupo on Org.id = Grupo.id_Organizacao
    INNER JOIN Organizacoes.Copias as Copia on Org.id = Copia.id_Organizacao

    WHERE  Grupo.id_grupo = 210 
    GROUP BY Org.id
    ORDER BY Org.id";

$result = $conn->query($sql);

echo " <tr>";


if ($result->num_rows > 0) {
    // dados de saída de cada linha
    while($row = $result->fetch_assoc()) {
    echo "id: " . $row["id"].  "id_Copia: " . $row["Copia.id"]. " - nome: " . $row["nome"]. " " . "<br>";
    }

} else {
    echo "0 results";
}
$conn->close();

?>

Answer 2

You can do it like this

$sql="
    SELECT
        Copia.id AS copia_id,
        Org.id,
        Org.nome 
        FROM Organizacoes as Org 

        INNER JOIN Organizacoes.Rel_Organizacoes as Grupo on Org.id = Grupo.id_Organizacao
        INNER JOIN Organizacoes.Copias as Copia on Org.id = Copia.id_Organizacao

        WHERE  Grupo.id_grupo = 210 
        GROUP BY Org.id
        ORDER BY Org.id";

$result = $conn->query($sql);

echo " <tr>";


if ($result->num_rows > 0) {
    // dados de saída de cada linha
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " copia-id: " . $row["copia_id"]. " - nome: " . $row["nome"]. " " . "<br>";
    }

} else {
    echo "0 results";
}