How to get in array data from table?

Question

I have a tags_ids array 1,3,2 and

data in my table:

+---------+----------+
| user_id | tag_id   |
+---------+----------+
|       1 |        1 |
|       1 |        2 |
|       2 |        1 |
|       2 |        2 |
+---------+----------+

I want to get the users ids into array, but not working:

foreach ($tags_ids as $i)
    {
        if ($result = $mysqli->prepare("SELECT `user_id` FROM `mytable` WHERE `tag_id`=?"))
        {
            $result->bind_param("i",$i);
            $result->execute();
            $result->bind_result($d);
            $result->fetch();
            $result->close();
        }

        if (!in_array($d,$users_ids)) $users_ids[] = $d;
    }

My result is always 1. Whats I'm doing wrong, and can I do it in a more simple way?

You need to call fetch() in a loop to get all rows. A single call to fetch() only retrieves one row. — Michael Berkowski
– Michael Berkowski, Commented Dec 21, 2013 at 15:00
See examples in the mysqli::fetch() documentation Something like while($result->fetch()) { $users_ids[] = $d; } — Michael Berkowski
– Michael Berkowski, Commented Dec 21, 2013 at 15:00

Anna · Accepted Answer · 2013-12-21 15:15:08Z

1

you need a while loop, you can find it here for full assist:http://www.youtube.com/watch?v=hO0YOOeJrOE
be sure to watch the other video's too, very helpfull.

goodluck, PHPNoob

answered Dec 21, 2013 at 15:15

Anna

112 bronze badges

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

Collectives™ on Stack Overflow

How to get in array data from table?

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