Hi,

Can someone help me? I created this script

PHP Code:

opendb();
$q = "select barang, warna from table1" where barang='meja'"; 
$r = querydb($q);
$d = mysql_fetch_array($r);

$q2 = "select barang, warna, harga, jumlah  from table2 where where barang='{barang}' and warna='{warna}'"; 

$before = array("{", "}");
$after  = array("\$d2['", "']");

$q2 = str_replace($before, $after, $child_query);
$r2 = querydb($q2);
$d2 = mysql_fetch_array($r2); 


After str_replace { } this would be $d2['barang'] and $d2['warna'] and the content will follow the first query ($q). But the problem the script could not run well. The varible won't get form $q

Can some one help me?

Thanks

PHP Code:

$q2 = "select barang, warna, harga, jumlah  from table2 where barang='{$d['barang']}' and warna='{$d['warna']}'"; 


First this line:

PHP Code:

$q = "select barang, warna from table1" where barang='meja'"; 


remove the " after table1. Now this line:

PHP Code:

$q2 = "select barang, warna, harga, jumlah  from table2 where where barang='{barang}' and warna='{warna}'"; 


Never actually gets used, $q2 gets replaced later on with:

PHP Code:

$q2 = str_replace($before, $after, $child_query);