Echo certain value from multidimensional array value when number of row results is different

PHP
1

I have array like this

stdClass Object
    (
        [field_id] => 10
        [value] => 46426
        [value_integer] => 0
    )

[1] => stdClass Object
    (
        [field_id] => 9
        [value] => 22
        [value_integer] => 0
    )

[2] => stdClass Object
    (
        [field_id] => 8
        [value] => 558/65
        [value_integer] => 0
    )

[3] => stdClass Object
    (
        [field_id] => 7
        [value] => Šturpolj
        [value_integer] => 0
    )

[4] => stdClass Object
    (
        [field_id] => 6
        [value] => 1
        [value_integer] => 0
    )

[5] => stdClass Object
    (
        [field_id] => 5
        [value] => 6
        [value_integer] => 0
    )

[6] => stdClass Object
    (
        [field_id] => 3
        [value] => 
        [value_integer] => 0
    )

[7] => stdClass Object
    (
        [field_id] => 4
        [value] => 4
        [value_integer] => 0
    )

)

and next row of array is:

stdClass Object
    (
        [field_id] => 11
        [value] => 2007
        [value_integer] => 0
    )

[1] => stdClass Object
    (
        [field_id] => 10
        [value] => 19574
        [value_integer] => 0
    )

[2] => stdClass Object
    (
        [field_id] => 9
        [value] => 33
        [value_integer] => 0
    )

[3] => stdClass Object
    (
        [field_id] => 8
        [value] => 192/34
        [value_integer] => 0
    )

[4] => stdClass Object
    (
        [field_id] => 7
        [value] => Poreč
        [value_integer] => 0
    )

[5] => stdClass Object
    (
        [field_id] => 6
        [value] => 3
        [value_integer] => 0
    )

[6] => stdClass Object
    (
        [field_id] => 5
        [value] => 2
        [value_integer] => 0
    )

[7] => stdClass Object
    (
        [field_id] => 4
        [value] => 1
        [value_integer] => 0
    )

[8] => stdClass Object
    (
        [field_id] => 3
        [value] => 
        [value_integer] => 249000
    )

[9] => stdClass Object
    (
        [field_id] => 2
        [value] => p+1+2
        [value_integer] => 0
    )

[10] => stdClass Object
    (
        [field_id] => 1
        [value] => 30%
        [value_integer] => 0
    )

)

I would like only to print value where [field_id] is equal to 9.
So the result would be in the first row 22 and in the second row 33.
The problem is that number of results in a row is not the same so I cant use “echo $results[2]->value”.
How can I get this?
Any idea?

Thanks

2

Can you not loop through the current row and just say where field_id == 9, echo the value?

3

Yes, I could do that in MySql but then I would have 20 queries for each row for each value before printing it.

4

I guess it’d be helpful to have more information about your setup then, I have no idea how it’d be 20 MySQL queries for each row to work with an existing array that you said you already have…

5

I can add it in MySQL “where ‘field_id’=9” and print it but then I need to query MySQL “where ‘field_id’=11” and then “where ‘field_id’=8” etc.

6

Use the Mysql IN operator.

Scott

7

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.