PHP / Mysql does not sort correctly [duplicate]

Question

I have a database and the following php code:

$result = mysqli_query($link, 'SELECT * FROM database ORDER BY Score DESC');
while ($row = $result->fetch_assoc()) {
   printf ("%s;%s\n", $row["Name"], $row["Score"]);
}

The database has rows Name as string and Score also as a string.

The Problem is the Score is not sorted correctly. Why?

Please remember that we cannot see your screen. You need to include in the question every relevant detail. The ORDER BY clause is not generally broken. — Álvaro González
– Álvaro González, Commented Jan 30, 2022 at 14:16
My one guess is that you have numeric strings: stackoverflow.com/a/5418033/231316 — Chris Haas
– Chris Haas, Commented Jan 30, 2022 at 14:20

M6R7M · Accepted Answer · 2022-01-30 14:35:02Z

0

change score column type to int

answered Jan 30, 2022 at 14:35

M6R7M

13 bronze badges

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

Collectives™ on Stack Overflow

PHP / Mysql does not sort correctly [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related