Get single column of data from mysql_query result

Question

I am currently using a mysql_query with the UNION function. This is the array that I get:

Array
(
    [0] => bob
    [added] => bob
)
Array
(
    [0] => test1
    [added] => test1
)

Is there a way that I can take this array, merge it, remove the added values, place the data in numerical order and make it look like this?:

Array
(
    [0] => bob
    [1] => test1
)

I know somebody'll ask me what have I done so far. Honestly, I have no idea where to go from here.

Do you have the PHP code where you are iterating over the mysql result object? — user2923779, Dec 24 '13 at 00:08

score 2 · Answer 1 · answered Dec 24 '13 at 00:08

2

array_reduce(
    array_map(function($i) {
        return $i[0];
    }, $data),
    function($result, $item) {
        $result[] = $item;
        return $result;
    },
    array()
);

or

call_user_func_array('array_merge',
    array_map(function($i) {
        return $i[0];
    }, $data)
);

answered Dec 24 '13 at 00:08

zerkms

249,484
69
436
539

I keep on receiving the error: `Parse error: syntax error, unexpected T_FUNCTION, expecting ')'` for both functions. – user2898075 Dec 24 '13 at 00:15
@user2898075: what php version do you use? – zerkms Dec 24 '13 at 00:16
@zerkms I'm currently using 5.2.17 – user2898075 Dec 24 '13 at 00:19
@user2898075: my code is php 5.3+. So prefer other solutions (just plain old `foreach` would be fine) PS: 5.2.17 is sooooooooooooooooooo old – zerkms Dec 24 '13 at 00:25
@zerkms If you wouldn't mind, can you show me how I could use `foreach` to accomplish what I want? I'm still a noob with arrays. – user2898075 Dec 24 '13 at 00:27
@user2898075: at least give it a try first – zerkms Dec 24 '13 at 00:29

Emilio Gort · Answer 2 · 2013-12-24T02:06:46.360

0

When you are fetching the data you can create your array eg:

 while($row = mysqli_fetch_array($result, MYSQLI_NUM){
   $newArray[] = $row[0];
 }

and from your current array you can do

$newArray = array();
foreach($array as $value){
    $newArray = array_push($newArray,$value[0]); 
}

edited Dec 24 '13 at 02:06

answered Dec 24 '13 at 00:09

Emilio Gort

3,475
3
29
44

score 0 · Answer 3 · answered Dec 24 '13 at 00:12

0

$array1=array_unique($array1);
$array2=array_unique($array2);
$result = array_merge ($array1,$array2);

answered Dec 24 '13 at 00:12

Bassam Essa

81
4

Get single column of data from mysql_query result

3 Answers3