sorting element in an object to be displayed using a while loop

Question

I am creating a simple drop-down menu displaying names:

    $sql = "SELECT id, 
                name
            FROM team 
            WHERE 1";
$stmt = $mysqli->prepare($sql);

if ($stmt) {
    $stmt->execute();    
    $stmt->store_result();

    $stmt->bind_result($id, $name);
    while ($stmt->fetch()) {
            echo '<option value=\"$id\">'.utf8_encode($name).'</option>';
    }       
} else {
    header('Location: ../../error.php?err=the database is corrupted');
}

I want to sort the option by alphabetic order. I am not sure which function should I use to sort the object before the loop. Any ideas?

tttpapi · Accepted Answer · 2014-11-26 09:24:03Z

2

$sql = "SELECT id, 
                name
            FROM team 
            WHERE 1 ORDER BY name ASC";

answered Nov 26, 2014 at 9:24

tttpapi

9392 gold badges10 silver badges34 bronze badges

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

Comments

Pupil · Accepted Answer · 2014-11-26 09:28:24Z

2

$sql = "SELECT `id`, `name` FROM team 
WHERE 1 ORDER BY name";

Default order of Database is ASC, so it works even if you do not write ASC.

answered Nov 26, 2014 at 9:28

Pupil

24k6 gold badges50 silver badges71 bronze badges

Comments

Jens · Accepted Answer · 2014-11-26 09:24:13Z

1

Do sorting in sql:

$sql = "SELECT id, 
                name
            FROM team 
            WHERE 1 order by name"

answered Nov 26, 2014 at 9:24

Jens

69.6k15 gold badges107 silver badges133 bronze badges

Comments

Choudhury Saadmaan Mahmid · Accepted Answer · 2014-11-26 09:25:49Z

1

Use ORDER BY in your query to get names sorted in alphabetical order.

$sql = "SELECT id, name
        FROM team 
        WHERE 1
        ORDER BY name ASC";

answered Nov 26, 2014 at 9:25

Choudhury Saadmaan Mahmid

1,3063 gold badges29 silver badges56 bronze badges

Collectives™ on Stack Overflow

sorting element in an object to be displayed using a while loop

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related