分离mysqli_fetch_array返回的两个数组

Question

I have created this

while ($data = mysqli_fetch_array($course_result, MYSQLI_ASSOC)) {
    print_r($data['course']);   
}  

Which prints this:

Array ( 
     [user_id] => 57 
     [course] => 6 
)
Array ( 
     [user_id] => 57 
     [course] => 5 
)

How can I create two variables that are equal to the values of the 'course' fields. So ideally, variable x ends up equalling to 6 and variable y equals 5 (essentially what I'm asking is how to extract the value from the mysql arrays and putting it into a variable)?

Answer 1

There is no something as you called "mysql_arrays". They are normal arrays.

You can do for example:

$array = array();
while ($data = mysqli_fetch_array($course_result, MYSQLI_ASSOC)) {
   $array[] = $data; // probably this way and not $array[] = $data['course'];
}  

$x = $array[0]['course'];
$y = $array[1]['course'];