Hi!
Does anybody know how to execute several queries or create several connections to db? i need to execute new query for each fetched row of first query. i've this:
//-----------------------------------
$conn = @OCILogon("user","pass","test");
$cursor = @OCIParse($conn,"select id,ord,title from lit.types order by ord");
$result = OCIExecute($cursor);
$i=1;
while (OCIFetchinto($cursor,$values)){ $query2 = "select id,ord,types,title from lit.subtypes where types = ".$values[0]." ";
$conn2 = @OCINLogon($conn);
$cursor2 = @OCIParse($conn2,$query2);
$result2 = OCIExecute($cursor2);
while(OCIFetchinto($cursor2,$values2)){
echo $i."!!!!!!!!!!";
}
OCILogoff($conn2);
$i++;
}
OCILogoff($conn);
//-------------------------------------
but it does not work. second connection is false. if i use $cursor2 = @OCIParse($conn,$query2); (whithout OCINLogon) then script fails.
