Can I pull specific data from an associative array?

[iPixel]

So i got a query

 

<?php
$sql_1 = "
SELECT * 
FROM   employee_directory EmpDir, pcsmgr.mvx_phone_history_io MVX
WHERE  EmpDir.managerid = '$DT_filenumber' AND
   EmpDir.branchid = '$branchid_SQL' AND
       MVX.calldate BETWEEN '$sDate' AND '$eDate' AND
       EmpDir.filenumber = MVX.dognet_user_id
       ORDER BY EmpDir.firstname ASC";
$go_1 = oci_parse($conn, $sql_1);
oci_execute($go_1);
$result_1a = oci_fetch_assoc($go_1);
?>

 

So now somewhere inside $result_1a is a field (( $result_1a['CALLTYPE'] )) that holds the call type

which let's say are "INCOMING" and "OUTGOING".

 

would i be able to only print/echo out all the rows that contain the calltype INCOMING, without having to touch the WHERE clause in the query statement?

 

or is oci_fetch_array() the only way to do something like it?

 

Thanks!

[premiso]

You can inside of your loop that displays the data, you do a simple if:

 

if ($result_1a['CALLTYPE'] == "INCOMING") {
     // print here
}

 

Would be how to do it.

[iPixel]

I'm thinking more like... now from the results you selected, only use the ones that have INCOMING as calltype and then other information based on those rows will be used, added, modified etc...