php - 返回不正确的数据顺序

Question

我有一个 MySQL 数据:

我尝试使用 jquery 获取它们:

         $.post(
            '../php/teacheradminfunction.php',
            {'functions':'getBadgeImg','topicSkill':$('#selTeachAdminBadgeDeleteSkill').val()},
            function(data) {
                $.each(data, function( key, value ) {
                    alert( key + ": " + value.badge_path );
                });
            },'JSON'
        );

我的 PHP 脚本:

$queryStmt = 'SELECT badge_path FROM badges WHERE badge_skill=:sqlSkill ORDER BY `index` ASC';
        $queryPrepare = $dba_connect->prepare($queryStmt);
        $queryPrepare->execute(array(':sqlSkill'=>$_POST['topicSkill']));
        $queryResult = $queryPrepare->fetchAll(PDO::FETCH_ASSOC);
        $queryPrepare->closeCursor();

        echo json_encode($queryResult);

我的问题是我需要有正确的顺序，我得到的是:

[{"badge_path":"..\\image\\badges\\Counting10_g.png"},{"badge_path":"..\\image\\badges\\Counting10_b.png"},{"badge_path":"..\\image\\badges\\Counting10_s.png"}]

预期结果:

[{"badge_path":"..\\image\\badges\\Counting10_g.png"},{"badge_path":"..\\image\\badges\\Counting10_s.png"},{"badge_path":"..\\image\\badges\\Counting10_b.png"}]

Answer 1

在您的数据库中提供适当的索引。根据您的查询，它返回正确的记录。

index    badge_rank
  1       GOLD
  2       SILVER
  3       BRONZE