simplify this code

[delfa]

I need to create somekind of tree view........ you know like:

Disease > cure > doctor > recipient > line

in my table i might have more than 1 doctor for the same Disease, more than 1 line for the same recipient and so on

so I made this code to get the content and display them like i want!

but the problem is when i have 2 records for the same cure/doctor/recipient or line, instead of this:

Malaria > Croflex > Dr. Jackie Chan > text > 4
Malaria > Croflex > Dr. Jackie Chan2 > text2 > 5

i want it to display:

Malaria > Croflex > Dr. Jackie Chan > text > 4
______________> Dr. Jackie Chan2 > text2 > 5

here is what i have done so far:

<?
include 'includes/conn.php';
$qx4 = "SELECT * FROM [Sql Codes] WHERE ((([Sql Codes].[query nome])='PHP_meduse_tvw_V2'));";
$tvw = odbc_exec($dados,"$qx4");

$querycode = odbc_result($tvw,"sql code");
$resID = odbc_exec($dados,"$querycode");

   $resultSet=array();

// Assign the field names to $resultSet['fieldNames']

   $fCount = odbc_num_fields($resID); 
   for ($i=1; $i<= $fCount; $i++){
   if (odbc_field_name($resID, $i) == 'doença' xor odbc_field_name($resID, $i) == 'inf'  xor odbc_field_name($resID, $i) == 'recipe nbr' xor odbc_field_name($resID, $i) == 'line nbr')
		{ 
	 $fNames[$i] = odbc_field_name($resID, $i); 
 		}
// echo $i.'<br>';
   }
//recuperar o nome dos campos
// Assign the records
$resultSet['fieldNames']=$fNames;
   for ($i=1; odbc_fetch_row($resID,$i); $i++){

  $record=array();
  for ($j = 1; $j <= $fCount; $j++){
  $fName = odbc_field_name($resID, $j); 	 
  if ($fName == 'doença' or $fName == 'inf' or $fName == 'recipe nbr' or $fName == 'line nbr'){
     $record[$fName]=odbc_result($resID, $j);
	 echo $record[$fName].' >';
	 }
  } echo '<br>';
//      $resultSet[$i]=$record; //don´t know hot to use this
   }
?>

[HalfaBee]

You will need to format the output using a table for ease.
Then keep a copy of the previous data and compare each new result with the old result and only echo it if it is different.

HalfaBee

[maybl8r03]

If you use a multi-dimension table to keep your data structure you can use a little recursive function to display this table easilly.

function populateme() 
{ 
  for ($iX=0; $iX < 50; $iX++) 
  { 
     for ($iY=0; $iY < 25; $iY++) 
     { 
          for ($iZ=0; $iZ < 10; $iZ++) 
          { 
               $arData[$iX][$iY][$iZ] = $iX + $iY + $iZ; 
          } 
     } 
  } 
  return $arData; 
} 

function showarray($arData) 
{ 
   $strResult = "<table border=\"1\" width=\"100%\">"; 
   @reset($arData); 
   while (list($strKey, $varValue) = @each($arData)) 
   { 
      $strResult .= "<tr><td>{$strKey}</td><td>"; 
      if (is_array($varValue)) 
      { 
           $strResult .= showarray($varValue); 
      } 
      else 
      { 
           $strResult .= "<font color=\"blue\"><b>{$varValue}</b></font>"; 
      } 
      $strResult .= "</td></tr>"; 
   } 
   $strResult .= "</table>"; 
   return ($strResult); 
} 

$arMyData = populateme(); 
echo showarray($arMyData);

This will give you a left to right table with a master detail view.

[delfa]

Interesting!

The question now is how do i fill array $arData with content from the database?