php oci_fetch_array and pass value to function issue

Answer 1

I think you probably want something like this:

function display_urls($url_array)
{
 echo "";
 if (is_array($url_array) && count($url_array)>0)
  {
   foreach ($url_array as $url)
   {
       echo "".$url['BM_URL']."";
       echo "".$url['CATEGORY']."";
   }
 }
 echo "";
}

$result = oci_parse($conn, "select * from bookmark where username ='$username'");
if (!$result){ $err = oci_error(); exit; }
  $r = oci_execute($result);

$url_array = array();
while( $row = oci_fetch_array($result, OCI_ASSOC)){
   $url_array[] = $row;
}

display_urls($url_array);

This will store all the information on the URLs in $url_array with a lookup by column name.