如何从数组中的单个数据库列/存储中提取值

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];

Answer 1

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'];  
}