Problem!! Please Help!!

obrienkev

Please help me solve this frustrating problem guys. Could really do with
solving this problem.

Why won't this work:

$items = array();

while ($row = mysql_fetch_assoc($result))
{
    $items[] = $row;
}

// tracker
$currentRow = 4;

foreach ($items as $value)
{
   foreach ($value as $filed_name => $value_name)
   {
        $cart->writeRow($currentRow, 0, $value_name);
        $currentRow++;
   }
}

When this does:

$items = array(
     array('Client'=>'client1', 'Director'=>'G.B', 'Manager'=>'E. Harte'),
);


$currentRow=4;

foreach($items as $item=>$value)
{
    $cart->writeRow($currentRow, 0, $value);
    $currentRow++;
}

mtmosier

What do you mean when you say it doesn't work? An error? Nothing displayed? Something displayed but not what you expect?

First thing I'd do is put a print_r($items); after your while loop and see what's in there.

thorpe

on top of that... your subject is not real discriptive. most people here are posting because they have problems they want help with.

next.

loops are a fairly resource hungry operation... why would you loop through a result to create an array, when the result itself will create an array. allot of extra work for nothing dont you think?

obrienkev

This $cart->writeRow writes the data to an excel spreadsheet. Basically I am trying to populate an array from a database query.
Then loop through that array to write the data out to the spreadsheet.

Any ideas??

mtmosier

While that's very interesting...

Originally posted by mtmosier
What do you mean when you say it doesn't work? An error? Nothing displayed? Something displayed but not what you expect?

First thing I'd do is put a print_r($items); after your while loop and see what's in there.

obrienkev

Sorry...when I say nothing works I mean it doesn't write the data from database to the excel sheet.
Whereas if I print the result it displays all the database data.

Then the data in the other example is manually entered into the array and when passed to the excel sheet it passes the data successfully. i.e. the data is entered into excel sheet.

Make sense?

Any ideas why this is??

mtmosier

It looks like in your working code you're passing an array to $cart->writeRow, and in the non-working example you're only passing it a string. I think you need to eliminate the inner foreach and pass it $value.

obrienkev

Could you show me an example of the code please?

obrienkev

Tried this but still prints no data on excel sheet

$currentRow=4;

foreach ($items as $value)
{

    $cart->writeRow($currentRow, 0, $value); 
    $currentRow++;

}

If I echo $value I just get: Array

What should I do please??