doble query

[putraaridana]

HELP, i want to use result from the first query in the second query
<?

$connection=odbc_connect("ok","ok","");
$query="SELECT * FROM tb_my where kode='001'";

$result=odbc_do($connection, $query);

while(odbc_fetch_into($result, $fields))
{
	$kode=$fields[0];

}

// i want to use the result from the first query but         doesn't work
//help !!!!!!!!!!!!

$query1="select from $query";	
$result=odbc_do($connection, $query1);

?>

[LordShryku]

So right now, your query1 variable looks like "select from SELECT * FROM tb_my where kode='001'"

Don't know what your trying but hope this will get you on the right track...

$cnx = odbc_connect( 'blah' , 'blah', 'blah' ); 
$query = odbc_exec( $cnx, "SELECT * FROM tb_my where kode='001'");
$i=0;
while(odbc_fetch_row($query)) { 
        $i++; 
        $field1 = odbc_result($query, 1); 
        $field2 = odbc_result($query, 2);
        $field3 = odbc_result($query, 3);
        $newQuery = odbc_exec($cnx, "SELECT something FROM somewhere WHERE somefield = '".$field3."'");
        $whatYouWant = odbc_result($newQuery, 1);
}
odbc_close($cnx);

[putraaridana]

ok i have table1 with data
| code | name |
001 name1
002 name2
the 2nd table
|code1| name1 |
101 name3
102 name4

the 3rd table
|code|code1|amount1
001 101 10

001 102 1

002 101 5

002 102 0

so the report look like

code 101 102
001 10 1

002 5 0

sum 15 1
how the query of it ?