sorting table row data with php

Question

<table class="tbmed">     
 <tr> 
  <th>R1</th> 
  <th>R2</th>
  <th>R3</th>
  <th>R4</th>
 </tr>


<?php
include ("config.php");
$sql = "SELECT id, r1, r2, r3, r4  FROM table order by id DESC ";         
  
$result = $conn->query($sql);

if ($result->num_rows > 0) {
 
    while($row = $result->fetch_assoc()) 
    {
        echo "<tr><td>". 
        $row["r1"]. "</td><td>".
        $row["r2"]. "</td><td>". 
        $row["r3"]. "</td><td>". 
        $row["r4"].'  
        "</td></tr>";
    }
    echo "</table>";
} else {
    echo "0 results"; 
}
$conn->close();

?>

I have some numerical data which are all positive, there may be repetitive values though. The above code gives the results like so:

R1 R2 R3 R4 
10 2  5  5
4  4  1  9
....

I'd like to sort the output in each row of the data table, and the result would be :

R1 R2 R3 R4 
2  5  5  10
1  4  4  9

How can I achieve this ? can someone help me please?

This would be easier I think if your database structure was more highly normalised (i.e. results all stored in a separate results table, with one result per row, and a foreign key back to the ID it belongs to) — ADyson
– ADyson, Commented May 10, 2022 at 12:33
I can't change db. I tried sort but couldn't get it done to get the results. — J.J
– J.J, Commented May 10, 2022 at 12:35
sort($row) will reset the array keys to a zero-based index. Instead of accessing the indices r1, r2 etc., you simply have to access 0, 1 etc. now. — C3roe
– C3roe, Commented May 10, 2022 at 12:39

Slava Rozhnev · Accepted Answer · 2022-05-10 12:49:37Z

1

You can use fetch_array instead fetch_assoc and apply sort function before output. Somehow like next:

if ($result->num_rows > 0) {
    while($row = $result->fetch_array(MYSQLI_NUM)) 
    {
        sort($row);
        echo '<td>';
        echo implode('</td><td>', $row);
        echo '</td>' . PHP_EOL;
    }
}

Try code online

answered May 10, 2022 at 12:49

Slava Rozhnev

10.2k6 gold badges27 silver badges43 bronze badges

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

1 Comment

J.J Over a year ago

Thanks a lot, Slava. Your code works, and simpler than mine.

Collectives™ on Stack Overflow

sorting table row data with php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related