oci function question

[123]

Hi

I am using PHP with Orcale

I was wondering is there a OCI function that lets you get the vaule of and sql statment based on column name or row,

Thank you

[Weedpacket]

Do you mean something from the [man]oci8[/man] functions?

[123]

Yes,

I have been looking for a OCI function to do this,

Currently I have a 3 column table and I am writing an sql statement for that selects each column individually and I am running the results of each statement in through the foreach loop. A would normally just fetch all data at once but I need to dispaly the data in different area.

$stmnt = oci_parse($dbc, "$sql"); 

$stmnt2 = oci_parse($dbc, "$sql2"); 

$stmnt3 = oci_parse($dbc, "sql3");

$r = oci_execute($stmnt);
$r2 = oci_execute($stmnt2);
$r3 = oci_execute($stmnt3);

$rows = oci_fetch_all($stmnt, $results);
$rows2 = oci_fetch_all($stmnt2, $results2);
$rows3 = oci_fetch_all($stmnt3, $results3);

for ($i = 0; $i < $rows; $i++) {
	foreach ($results as $data){ 
		foreach ($results2 as $data2){ 
			foreach ($results3 as $data3){

			print '<div class="topofpage"><p>' .$data[$i] .'</p></div>';
			print '<div class="middleofpage"><p>' .$data2[$i] .'</p></div>';
			print '<div class="bottomofpage"><p>' .$data3[$i] .'</p></div>';
		}
	}
}
}

this away of writing the code seems very long winded espically when I am working with more than 3 columns, so i was wondering if there is a OCI function that could help with this or a more suitable way to write the code.

Thank you in advance for your hlep