Access values in an array

[skicrud]

I have created the following function:

function get_prepress_checked_items($job_number){

        $checked_items=array();

        $sql='SELECT * from rs_prepress_log where job_number='.sprintf('%d',$job_number);

        $query=$this->db->query($sql);

        $query->result_array(); 

        //$rtn=$query->result(); #returns the results from the log file   

      // $checked_items=array();

        foreach($query->result_array() as $row)

        {

        $checked_items[]=$row['item_checked'];

        $checked_items[]=$row['item_comment'];

           

        }

 

        return $checked_items;

    }

when I execute the following code

echo '<pre>';var_dump($checked_items);echo '</pre>';

 

I get back:

array(4) {

  [0]=>

  string(3) "A00"

  [1]=>

  string(9) "comment 1"

  [2]=>

  string(3) "A20"

  [3]=>

  string(9) "comment 2"

}

My question is how do I set up a loop to get the "comment 1" and "comment 2" variables?

[Maq]

Are the array elements always going to be in the same order/position?

[skicrud]

Yes, however there might be more or less depending on how many entries are in the db. There might be times when there are no comments but then the value will be null and that is ok.

[Maq]

OK, is it always going to be the comment is every other element?

[skicrud]

Yes

 

[Maq]

So if every other element in the array is going to be a comment then you just grab every other element.  Or, in your case, it looks like all the ODD indexed elements.  You can probably achieve this by using the modulus operator.