Storing values from SQL tables into different PHP arrays

Question

In my course_status table. I have 3 columns(course_name, course_status, student_id). When I searched for a student id, the course_name cell table should change according to the status. This is the query I am using to get pending, completed and incomplete courses into my arrays.

$done_course = array();
$progress_course = array();
$pending_course = array();
 while($row2 = mysqli_fetch_assoc($retval2)){
        if($row2['course_status'] = 'pending') {
                $pending = True; 
                array_push($pending_course, $row2['course_name']);}
         if($row2['course_status'] = 'In_progress')  {
                $progress = True;                                                 
                 array_push($progress_course,$row2['course_name']); } 
          if($row2['course_status'] = 'done') {
                 $done = True; 
                 array_push($done_course, $row2['course_name']); }

My question is when I run the code $done_courses will store all courses including pending and incomplete. How do I prevent it and make it only store completed courses?

So what is the question? You need to show us more detail e.g. how you output the cell table, and how you want to change it dependent on the status. — Nick
– Nick, Commented Apr 17, 2019 at 2:03
@Nick, I use js to output the cell but I just need to fogure how to get the courses into the arrays. — cheunology
– cheunology, Commented Apr 17, 2019 at 2:07

Rasa Mohamed · Accepted Answer · 2019-04-17 02:45:09Z

1

My question is when I run the code $done_courses will store all courses including pending and incomplete.

I don't think this was printing mistake if($row2['course_status'] = 'pending') { you are comparing with single = instead of ==

Once you change this = to this == it will work fine...

answered Apr 17, 2019 at 2:45

Rasa Mohamed

8921 gold badge6 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Storing values from SQL tables into different PHP arrays

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related