PHP SQL query id from table with multiple values in rows

Question

I'm having an issue querying multiple values from rows that have a certain value. I use the SQL code below to grab column "group_id"'s values if the "id" equals 999. In the "xx_groupmap" table, the id 999 shows up three times with different values. Below is my table.

table xx_groupmap
-------------------
id   |  group_id
-------------------
999  |  2
999  |  7
999  |  8

Below is the code I use

        $db = JFactory::getDbo();
        $query = "SELECT group_id FROM xx_groupmap WHERE id = '999'";
        $db->setQuery($query);
        $results = $db->loadObjectList();
        foreach ($results as $t) {
        }

So in the end when I want to return the three values of id 999 I use this code

echo $t->group_id;

but it only outputs one number. How do I build an array with the three values from id 999?

vaso123 · Accepted Answer · 2014-11-04 14:52:17Z

3

Thats because, when you are in the foreach, $t is always updated, and you will get tha last $t only. Put them into an array.

$ids = array();
foreach ($results as $t) {
    $ids[] = $t->group_id;
}
var_dump($ids);

answered Nov 4, 2014 at 14:52

vaso123

12.4k4 gold badges37 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

PHP SQL query id from table with multiple values in rows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related