How to select specific part of an array when two arrays are returned?

Question

In a while loop I have:

$row = mysql_fetch_array($result)

Held under $row are two arrays which when shown using print_r display the following:

Array
(
[4] => Post Content
[value] => Post Content
)

Array
(
[4] => Post Title
[value] => Post Title
)

How can I choose "Post Content" and "Post Title" from the array without it being repeated in the while loop?

The original version of this question confused the duplication with the problem. The issue is how to extract the second array [value] when they are both held under $row.

I think there's another question here which is: why do you have two related pieces of information being returned in two different rows of a query? — nickf
– nickf, Commented Apr 6, 2009 at 13:25
Indeed. The project involved migrating data from the database, for which I didn't design. So for now, the issue is solved. Thank you for your interest. — nickcharlton
– nickcharlton, Commented Apr 7, 2009 at 8:47

Pim Jager · Accepted Answer · 2009-03-29 08:38:57Z

2

You can also make sure the values won't be insterted twice using mysql_fetch_assoc() or mysql_fetch_row().
Thus:

$row = mysql_fetch_assoc($result);
Array
(
['value'] => Post Content
)

Array
(
['value'] => Post Title
)

answered Mar 29, 2009 at 8:38

Pim Jager

32.2k17 gold badges75 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alister Bulman · Accepted Answer · 2009-03-29 00:05:24Z

1

You want to make sure an array only has unique values? If that doesn't work with the arrays in an array, it's classic de-duping with a store of what you've already seen.

$dedupedValues = array()
foreach ($row as $items) {
    if (! is_set($dedupedValues[$items['value']])) {
        $dedupedValues[$items['value']] = true;  // we have this value
        echo "echo the title/value....";
    }

}

Another alternative is to improve the SQL that gets the data to begin with to avoid duplicates in the first place (see: MySQL 'DISTINCT')

answered Mar 29, 2009 at 0:05

Alister Bulman

35.3k9 gold badges75 silver badges113 bronze badges

Comments

Maiku Mori · Accepted Answer · 2009-03-29 12:21:42Z

Pim Jager showed much better way of doing this, but if you insist on using mysql_fetch_array():

$i = 0;
$size = count($row);
if ($size > 0) {
  while ($i < floor($size / 2)) {
   ..... = $row[$i];
   $i += 1;
  }
}

Edit:

After reading again, I'm not sure if I quite understand the question.

If you have nested arrays for example:

$row = array('data1' => array('orange', 'banana', 'apple'),
             'data2' => array('carrot', 'collard', 'pea'));

And you want to access each array then:

$data1 = $row['data1'];
// = array('orange', 'banana', 'apple')
$data2 = $row['data2'];
// = array('carrot', 'collard', 'pea')
// OR
$orange = $row['data1'][0];
$banana = $row['data1'][1];
$apple = $row['data1'][2];
$carrot = $row['data2'][0];
// ... so on..

Taking that in account the loop looks like this:

$i = 0;
$size = count($row);
if ($size > 0) {
  while ($i < floor($size / 2)) {
   $something = $row['data1'][$i]; //Or $row[0][$i]; using your example
   $something = $row['data2'][$i]; //Or $row[1][$i]; using your example
   $i += 1;
  }
}

But I really suggest using mysql_fetch_assoc() and foreach loop, like in Pims Jagers example

nickcharlton · Accepted Answer · 2009-04-06 13:11:56Z

0

Final solution was found by slightly restructuring the original query as per Topbit's suggestion and the use of two while loops.

while($row_title = mysql_fetch_array($result_title)){
$row_body = mysql_fetch_array($result_body);

    // code
}

Thank you to all those who suggested solutions.

answered Apr 6, 2009 at 13:11

nickcharlton

8563 gold badges13 silver badges23 bronze badges

Collectives™ on Stack Overflow

How to select specific part of an array when two arrays are returned?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related