Properly Displaying Sorted SQL Rows

Question

I am trying to sort my SQL database alphabetically by location. I executed the command: SELECT * FROM users ORDER BY location on the phpMyAdmin website, and the users are now indeed ordered alphabetically by location on the online database. However they still don't display in alphabetical order on our website. Here is the code where I output the relevant SQL data:

<div>
  <table id="checkintable">
    <tr>
        <th>Name</th>
        <th>Location</th>
        <th>Comment</th>
    </tr>                  
  <? $result = mysql_query("SELECT fullname, location, comment FROM users"); ?>
  <? while ($row = mysql_fetch_array($result)): ?>
    <tr class="tables">
        <td><?= $row["fullname"]?></td>
        <td><?= $row["location"]?></td>
        <td><?= $row["comment"]?></td>
    </tr>
    <br>
  <? endwhile ?>
  </table>
</div>

Am I doing something wrong in this code? I want to display the table in the same order that the online database is ordered in, but it isn't working.

I don't understand why you're missing "order by location". You even mention that you used it from the mysql command line. — hookenz
– hookenz, Commented Dec 7, 2011 at 7:50

Otiel · Accepted Answer · 2011-12-07 07:48:33Z

3

You are missing the ORDER BY location in your query:

$result = mysql_query("SELECT fullname, location, comment FROM users ORDER BY location");

answered Dec 7, 2011 at 7:48

Otiel

18.8k17 gold badges82 silver badges127 bronze badges

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

Comments

Michał Powaga · Accepted Answer · 2011-12-07 07:49:22Z

1

Change your:

mysql_query("SELECT fullname, location, comment FROM users")

to:

mysql_query("SELECT fullname, location, comment FROM users ORDER BY location")

answered Dec 7, 2011 at 7:49

Michał Powaga

23.4k8 gold badges55 silver badges62 bronze badges

Collectives™ on Stack Overflow

Properly Displaying Sorted SQL Rows

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related