Filling array with data from one specified MySQL field

Question

The field: Friends, and contains something like "2,3,6,3,67,97" the numbers are user ID's.

i want to know if there is a way to get those numbers into an array?

Thanks in advance

As a side note: Having a field like this is a bad idea in 99% of all cases. Look into database normalization and create a table like CREATE TABLE friended_user ( user_id INT, friended_user_id INT) and do some JOINs — klaustopher
– klaustopher, Commented Mar 10, 2012 at 21:28

Starx · Accepted Answer · 2012-03-10 15:27:06Z

2

$data = "2,3,6,3,67,97";
$dataarray= explode(",",$data);

answered Mar 10, 2012 at 15:27

Starx

79.3k50 gold badges187 silver badges266 bronze badges

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

Comments

Jared · Accepted Answer · 2012-03-10 15:32:29Z

1

You could do something like

$counter = 0;
$array = array();
while($row = mysql_fetch_array($sql)) {
    $array[$counter] = explode(",", $row['friends']) // or whatever the column is called
    $counter++;
}

So for the first entry in the database,

$array[0][0] = 2
$array[0][1] = 3 // etc etc...

Apologies if the code is wrong, been a while since I've worked with multi-dimensional arrays. Hope the concepts helped though :)

answered Mar 10, 2012 at 15:32

Jared

4064 silver badges14 bronze badges

Collectives™ on Stack Overflow

Filling array with data from one specified MySQL field

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related