SQL results into PHP array, not expected output

Question

I am trying to get all the results from 1 column into an array. I tried the following below but all I get from the output is "Array".

$sql = "SELECT pickID FROM picks WHERE userID = 2 ";
$query = mysql_query($sql);
$result = mysql_fetch_array($query);

$i = 0;
$pickArray = array();

foreach($result as $row) {
    $pickArray[$i] = $row['pickID'];
    $i++;
}

echo $pickArray;

note- your current code will only return 1 value as mysql_fetch_array() ->Returns an array that corresponds to the fetched row and moves the internal data pointer ahead. If more than 1 value is desired, remove $result = mysql_fetch_array($query); and change foreach($result as $row) { to while($row = mysql_fetch_array($query)){ — Sean
– Sean, Commented Aug 12, 2014 at 23:54

kimbarcelona · Accepted Answer · 2014-08-13 00:00:50Z

4

You need to use print_r not echo. See why you need to use print_r for viewing values of an array. Echo on the other hand is being used to display value of a variable not array.

print_r($pickArray);

Also a note from Sean,

remove $result = mysql_fetch_array($query); and change foreach($result as $row) { to while($row = mysql_fetch_array($query)){

edited Aug 13, 2014 at 0:00

answered Aug 12, 2014 at 23:47

kimbarcelona

1,1462 gold badges9 silver badges19 bronze badges

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

2 Comments

locnguyen Over a year ago

Your answer and sean's answer did the job

kimbarcelona Over a year ago

See my Edit using Sean's suggestion

Collectives™ on Stack Overflow

SQL results into PHP array, not expected output

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related