PHP / Mysql does not sort correctly

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, Jan 30 '22 at 14:16
My one guess is that you have numeric strings: https://stackoverflow.com/a/5418033/231316 — Chris Haas, Jan 30 '22 at 14:20

score 0 · Answer 1 · answered Jan 30 '22 at 14:35

0

change score column type to int

answered Jan 30 '22 at 14:35

M6R7M

1
3

PHP / Mysql does not sort correctly

1 Answers1