return variables from array using a function

Question

I retrieve data from database using this query:

SELECT * FROM tickets_departement_groups WHERE group_id = '{$user_group}'

$user_group is already defined, and I fetch the data using mysql_fetch_array, like this:

foreach ($query->result_array() as $row)
{
    return $row['departement_id'];
}

All this is under a function called get_departement_id(), So when I do echo get_departement_id(); it prints last departement ID, but I have many of them. What I want to do is to output all the department IDs for a given query.

I couldn't help but notice that as well. Must be the GUI programmer in me, but I resisted commenting (until now). :) — Sam
– Sam, Commented Mar 31, 2011 at 18:53
@Sam: Hehe your resistance is better than mine. Mine appears to be ... well, futile. — Lightness Races in Orbit
– Lightness Races in Orbit, Commented Mar 31, 2011 at 23:13

Jase · Accepted Answer · 2011-03-31 18:31:18Z

3

create and array and return the array?

$id_list = array();
foreach($query->result_array()  as $row){
    $id_list[] = $row['departement_id'];
}

return $id_list;

answered Mar 31, 2011 at 18:31

Jase

5993 silver badges9 bronze badges

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

1 Comment

Sam Over a year ago

This sounds like the most flexible solution. This allows the caller to do whatever it wants with the data rather than narrowing it to just printing (unless that is the only purpose...).

Collectives™ on Stack Overflow

return variables from array using a function

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related