PHP Fusing two arrays

Question

How to connect 2 arrays? I want that $new[$code]=$color, how can I do this? Below is my code:

$sql = "SELECT user_id, user_color FROM dotp_users";
$result = mysql_query($sql) or die(mysql_error());
$code = $color = array();
while($row = mysql_fetch_assoc($result)) {
        $code[] = $row['user_id'];
        $color[] = $row['user_color'];
}

Declare the variable $new = array();, then inside while loop $new[$row['user_id']] = $row['user_color'] — Saumini Navaratnam
– Saumini Navaratnam, Commented Jun 20, 2015 at 12:36
In the while loop or later? In while $new[$row['user_id']] = $row['user_color'];. Otherwise php.net/manual/en/function.array-combine.php, — chris85
– chris85, Commented Jun 20, 2015 at 12:36

Saumini Navaratnam · Accepted Answer · 2015-06-20 12:41:08Z

1

Declare the variable outside the while loop

$new = array();

Then inside while loop

$new[$row['user_id']] = $row['user_color'];

answered Jun 20, 2015 at 12:41

Saumini Navaratnam

8,9455 gold badges47 silver badges75 bronze badges

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

Comments

chris85 · Accepted Answer · 2015-06-20 12:39:48Z

1

In the while loop...

$sql = "SELECT user_id, user_color FROM dotp_users";
$result = mysql_query($sql) or die(mysql_error());
$code = $color = array();
while($row = mysql_fetch_assoc($result)) {
        $new[$row['user_id']] = $row['user_color'];
}

If you need the arrays seperate for some reason you can do it later using array_combine, http://php.net/manual/en/function.array-combine.php.

$sql = "SELECT user_id, user_color FROM dotp_users";
$result = mysql_query($sql) or die(mysql_error());
$code = $color = array();
while($row = mysql_fetch_assoc($result)) {
        $code[] = $row['user_id'];
        $color[] = $row['user_color'];
}
...
$new = array_combine($code, $color);

answered Jun 20, 2015 at 12:39

chris85

23.9k7 gold badges36 silver badges51 bronze badges

Collectives™ on Stack Overflow

PHP Fusing two arrays

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