Multidimentional arrays help!!!!

[finger2003]

I am newbie in arrays use. I need i litle help in my code.If any expert can help me, i'll apreciatte 🙂

The troble is: My code selects from mysql DB results from dates (hink in a calendar) and selected dates are a array. From this array, i need to do another query and some calcs using results. The result will be another array, but i cant print right values from this second array (multidimentional).

here is my code:

---

$query = "SELECT * from itens where $oque_query AND date_schedule >= '$inidate' AND date_schedule <= '$enddate' AND $condicao_q_q $status_q_q $cat_id_q ORDER BY $order_q";
$result = mysql_query($query,$db);
$number=mysql_numrows($result);

$nrows = mysql_num_rows($result);
$row = 0;
while( $row < $nrows )
{

$date_schedule = mysql_result($result,$row,"date_schedule");

$unique_dia[$row] = $date_schedule;
$unique_day_s = array_unique ($unique_dia); // calc unique days (main array)

    $row++;
 }

foreach ($unique_day_s as $v){

$query = "SELECT op_own, item_id, date_schedule, item_quantity, data_prometida, final_prod_time, express from itens WHERE $oque_query AND date_schedule = '$v' AND $condicao_q_q $cat_id_q $status_q_q ORDER BY date_schedule";
$result = mysql_query($query,$db);
$number=mysql_numrows($result);

$result = mysql_query("SELECT item_id, date_schedule from itens WHERE $oque_query AND date_schedule = '$v' AND $cat_id_q $status_q_q ORDER BY date_schedule"); //query using main array - returns second array

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

$dt_schedule = $row["date_schedule"];
$prog_year = substr ( $dt_schedule, 2, 2 );
$prog_month = substr ( $dt_schedule, 4, 2 );
$prog_day = substr ( $dt_schedule, 6, 2 );
$prog_date_str = strtotime ("$prog_year-$prog_month-$prog_day");

$prom_oneless = $prom_date_str; //data prometida menos 1 dia

$delay_days_str = $final_date_str - $prom_oneless;
$delay_days = date("d","$delay_days_str");

$delay_days_t[$v][?] = $delay_days; // here is the trouble!!! I dont know what to do

}

echo"
$v<br>
$delay_days_t[????????]"; //here is the trouble!!! I dont know what to do

}

[drawmack]

wrap your code with php bb tags and then I'll read it.

[finger2003]

maybe this?

---

$query = "SELECT * from itens where $oque_query AND date_schedule >= '$inidate' AND date_schedule <= '$enddate' AND $condicao_q_q $status_q_q $cat_id_q ORDER BY $order_q"; 
$result = mysql_query($query,$db); 
$number=mysql_numrows($result); 


$nrows = mysql_num_rows($result); 
$row = 0; 
while( $row < $nrows ) 
{ 

$date_schedule = mysql_result($result,$row,"date_schedule"); 


$unique_dia[$row] = $date_schedule; 
$unique_day_s = array_unique ($unique_dia); // calc unique days (main array) 


$row++; 
} 


foreach ($unique_day_s as $v){ 

$query = "SELECT op_own, item_id, date_schedule, item_quantity, data_prometida, final_prod_time, express from itens WHERE $oque_query AND date_schedule = '$v' AND $condicao_q_q $cat_id_q $status_q_q ORDER BY date_schedule"; 
$result = mysql_query($query,$db); 
$number=mysql_numrows($result); 

$result = mysql_query("SELECT item_id, date_schedule from itens WHERE $oque_query AND date_schedule = '$v' AND $cat_id_q $status_q_q ORDER BY date_schedule"); //query using main array - returns second array 


while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { 

$dt_schedule = $row["date_schedule"]; 
$prog_year = substr ( $dt_schedule, 2, 2 ); 
$prog_month = substr ( $dt_schedule, 4, 2 ); 
$prog_day = substr ( $dt_schedule, 6, 2 ); 
$prog_date_str = strtotime ("$prog_year-$prog_month-$prog_day"); 

$prom_oneless = $prom_date_str; //data prometida menos 1 dia 

$delay_days_str = $final_date_str - $prom_oneless; 
$delay_days = date("d","$delay_days_str"); 


$delay_days_t[$v][?] = $delay_days; // here is the trouble!!! I dont know what to do 



} 

echo" 
$v<br> 
$delay_days_t[????????]"; //here is the trouble!!! I dont know what to do 


} 

----------------------------------------------

[finger2003]

up

[maybl8r03]

A simple excercise might help

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);

Going through this might help you get a grasp of multi-dimensioned array.