How to sort user data by id

by

As I told in comments you can use a nested while loop for this

Updated

while ($data = mysqli_fetch_array($c_result)) {
    $messages[] = $data["msg_body"];
    $user_from = $data["user_from"];
    if($user_from==38){
        $d_query = "SELECT * FROM register WHERE id='$user_from'";
        $d_result = mysqli_query($conn,$d_query);
        while ($fdata = mysqli_fetch_assoc($d_result)) {
            $frname = $fdata["firstname"];


        }

    } //This is end of if
        echo "$frname sent you a message <br> $messages[]";
}//This END of First while loop

I have wrote what I have understood. Hope it helps you

More Related Contents:

  1. Comma separated numeric values – PHP CodeIgniter
  2. php+mysql Fatal error: Call to undefined function mysql_connect()
  3. Using PHP data in MySQL [closed]
  4. drop down menu using php and mysql [closed]
  5. php code for multiple search box after connecting to mysql [closed]
  6. Checking the availability of rooms
  7. How to add Hyperlink on php/html table that displays information from mysql database [closed]
  8. PHP + MySQL transactions examples
  9. How to display errors for my MySQLi query? [duplicate]
  10. How to retrieve images from MySQL database and display in an html tag
  11. Automated or regular backup of mysql data
  12. Fatal error: Call to undefined function session_register()
  13. PHP: Warning: sort() expects parameter 1 to be array, resource given
  14. PHP date() format when inserting into datetime in MySQL
  15. implement LIKE query in PDO
  16. Special characters in PHP / MySQL
  17. Fetching single row, single column with PDO
  18. MySQL db question marks instead of hebrew characters..?
  19. “Warning: Cannot modify header information – headers already sent by” error [duplicate]
  20. IP address storing in MySQL database using PHP [duplicate]
  21. How I can create installer for website. PHP mysql [closed]
  22. “No such file or directory” or “No such host is known” when running migrations
  23. How to join two tables with ssp.class.php
  24. How to convert IPv6 from binary for storage in MySQL
  25. Eloquent many-to-many-to-many – how to load distant relation easily
  26. Using Prepared Statement, how I return the id of the inserted row?
  27. How does {} affect a MySQL Query in PHP? [duplicate]
  28. When should I close a database connection in PHP?
  29. php connection pooling mysql [duplicate]
  30. Limit pagination page number

Leave a Comment