How can I sort by variable within a foreach loop (php)?

Question

in my for each loop I want to sort my options by the value of my variable $total resp. by the data-total:

     <select>
                   <option data-total="0" value="" selected>--</option>
                   <?php 

                    $pdo = Database::connect();


                    $sql = "SELECT  *  FROM table_a;" ;

                    foreach ($pdo->query($sql) as $row) {

                            $a = $row['a'];
                            $number_a = $row['number_a'];               

                            $sql2 = "SELECT  *  FROM table_b WHERE a = '$a';" ;
                            $number_b = 0;

                            foreach ($pdo->query($sql2) as $row2) {
                                $number_b+= $row2['number']; 
                            }

                            $total = $number_a - $number_b;

                            echo '<option data-total="'.$total.'" value="'.$a.'">'.$a;

                    }

                    Database::disconnect();

                        ?>                                                          
     </select>

Is this possible? Thank you very much!

Harshit · Accepted Answer · 2015-08-20 10:51:51Z

1

In your for loop do something like this

$total_arr = array();
foreach ($pdo->query($sql) as $row) {

                            $a = $row['a'];
                            $number_a = $row['number_a'];               

                            $sql2 = "SELECT  *  FROM table_b WHERE a = '$a';" ;
                            $number_b = 0;

                            foreach ($pdo->query($sql2) as $row2) {
                                $number_b+= $row2['number']; 
                            }

                            $total = $number_a - $number_b;
                            $total_arr[$a] = $total;

                    }

arsort($total_arr);
foreach ($total_arr as $key => $val) {
    echo '<option data-total="'.$val.'" value="'.$key.'">'.$key;
}

edited Aug 20, 2015 at 10:51

answered Aug 20, 2015 at 10:08

Harshit

5,18711 gold badges51 silver badges96 bronze badges

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

8 Comments

peace_love Over a year ago

One question: $a now doesn't have the right value. It has now for all options the same value, but in my code above it had the right value.

peace_love Over a year ago

Thank you! But this doesn't give me the value of $a it gives me a 0and a 1

peace_love Over a year ago

do I need a multidimensional array for this?

peace_love Over a year ago

I cannot find what you have changed unfortunately

Harshit Over a year ago

Have you tried this one ? changed to arsort($total_arr);

|

Collectives™ on Stack Overflow

How can I sort by variable within a foreach loop (php)?

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related