Using Array Elements

obrienkev

How do I pass certain elements of an array into an echo or a function like below?? Don't want to pass all elements

$items = array();

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

$currentRow=4;

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

bradgrafelman

You would use foreach() exactly as you have done.

At this point, I see nothing wrong with your script (assuming you've correctly defined 'writeRow()'). Why are you asking us? Are you getting an error or unpexected result?

If so, post as much information as you can give us. What error/warnings/notices are you getting? What output were you expecting, and what did you receive?

Installer

In this line:

$items[] = $row;

you are making $items a multidimensional array ($row is an itself array of values, one value for each column). So this line inside the foreach:

$cart->writeRow($currentRow, 0, $item['desired_column']);

would write one column value from each row. Unless you want to pass an array to writeRow(). Then you could do something like this:

$array_to_write = array($item['desired_row_1'], $item['desired_row_2']);
$cart->writeRow($currentRow, 0, $array_to_write);

Is that what you mean?

obrienkev

Hi Installer,

Yeah think that's what I want.

At present my foreach loop passes ALL the values of array whereas I only want certain values passed.

So do I put the $array_to_write in my foreach loop??

Cheers.

Installer

Yes, since $item contains the full set of values for each result row. BTW, I see I made a typo in the code (surprise). Where I put "$item['desired_row_x']" it should be "$item['desired_column_x']". You'd subtitute the names of the columns you want, of course.

obrienkev

So if I want to use info from three array elements which have values from client, director, manager fields I would use:

$items = array();

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

$currentRow=4;

foreach ($items as $item)
{
$array_to_write = array($item['client'], $item['director'], $item['manager']);
$cart->writeRow($currentRow, 0, $item);
$currentrow++;
}

Is this correct???

Installer

That should do it.

Installer

Wait--I didn't look close enough. This line:

$cart->writeRow($currentRow, 0, $item);

should be:

$cart->writeRow($currentRow, 0, $array_to_write);

Edit: Like I said, that should work, but you could also condense the whole thing to this:

$currentRow = 4; 
while ($row = mysql_fetch_assoc($result)) 
{ 
    $array_to_write = array($row['client'], $row['director'], $row['manager']); 
    $cart->writeRow($currentRow++, 0, $array_to_write); 
}