将sql查询结果插入新查询

Question

So the task is:

• 1. Do a query like Select * from table.
• 1. Take some cell value
• 1. Insert this value to a new query.

What do I have so far:
$Conn = odbc_connect("..."); $Result = odbc_exec("Select ..."); while($r = odbc_fetch_array($Result)) // showing result in a table

Here it looks like I should use the r array and insert data like

$var = r['some_field'];
$query = 'Select * from table where some_field = {$var}";

But how can I fill this array with values and how to make it available out of while loop? Here I'm using odbc, but it doesn't matter, I need the algorithm. Thanks.

The whole code looks like:

<?php
$data = array();
$state = 'false';
if($_REQUEST['user_action']=='')
{
    $Conn = odbc_connect("...");
    $data = array();     

    if($_REQUEST['name']!='')
    {                                                 
        $Result = odbc_exec($Conn, "select ...");
        //Showing result table
        while($r = odbc_fetch_array(Result))
        {                 
            array_push($data, $r['cardgroup']); 
            $state = 'true';     
        }
            //   print_r($data);  WORKS;             
    }    
}  

if ($_REQUEST['user_action'] == 'action1')
           {     
                //I need to use $data HERE. Doesn't work
                // $state = 'false' here...
           }
?>

Answer 1

Define array outside while loop

$data = array();//defining
while($r = odbc_fetch_array($Result))

use array_push() inside while loop

array_push($data, $r['some_field']);

then try to print array of complete data outside loop

print_r($data);

Updates

---

Place $data = array(); at the top of first IF statement. Try this code:

$data = array();//at top   
if($_REQUEST['user_action']=='')
{
    $Conn = odbc_connect("...");  

    if($_REQUEST['name']!='')
    {                                                 
        $Result = odbc_exec($Conn, "select ...");
        //Showing result table
        while($r = odbc_fetch_array(Result))
        {                 
            array_push($data, $r['cardgroup']); 
        }
            //   print_r($data);  WORKS;             
    }    
}  

if ($_REQUEST['user_action'] == 'action1')
{     
      //print_r($data) works here also
}