How to extract values from single database column / store in array

Question

I am hoping someone can help me with this. I am trying to extract all the values from a single column of a database and store the returned values in a numeric array.

$num = 1;
 $q = "SELECT `uninum` FROM `participants` WHERE `islecturer` = '".$num."'";
    $result = @mysqli_query ($dbcon, $q);
    $storeArray = array();
    while ($row = mysqli_fetch_array($result, MYSQLI_NUM)) {
        $storeArray [] =  $row['uninum'];  
    }


    echo $storeArray [1];

So whats not working? For a start you can remove the error suppression from the query @ is almost never a good idea — Steve
– Steve, Commented Aug 18, 2015 at 15:22
Oh okay, thanks Steve. At present I have not got it to work at all. I am getting an error message for this line $storeArray [] = $row['uninum'];for 'Undefined index' for 'uninum' — Ray
– Ray, Commented Aug 18, 2015 at 15:29

Steve · Accepted Answer · 2015-08-18 15:33:25Z

2

The second parameter to mysqli_fetch_array sets the array type. You have set it to a numerical index. You want an associative index:

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { //correct flag
    $storeArray [] =  $row['uninum'];  
}

Or just use the mysqli_fetch_assoc function instead:

while ($row = mysqli_fetch_assoc($result)) { 
    $storeArray [] =  $row['uninum'];  
}

answered Aug 18, 2015 at 15:33

Steve

20.5k5 gold badges47 silver badges71 bronze badges

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

1 Comment

Steve Over a year ago

@Ray No problem, glad i could help

Collectives™ on Stack Overflow

How to extract values from single database column / store in array

1 Answer 1

1 Comment

Your Answer

Collectives™ on Stack Overflow

How to extract values from single database column / store in array

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related