mysql problems

[aghast_bg]

hello everybody,

i have this nasty problem - i want to arrange a table in a new way than previously. here is the table:

+--+----+-----+-----+-----+
|id|name| jar| jad| gif|
+--+----+-----+-----+-----+

| 1|a |a.jar|a.jad|a.gif|
| 2|C |c.jar|c.jad|c.gif|
| 3|b |b.jar|d.jad|b.gif|
+--+----+-----+-----+-----+

i want to arrange the table in alpahbetical order by name. i tried mysql_query ("ALTER TABLE games ORDER BY name;"); but the 'id' kept the wrong way. the problem is that i want to make the table to look this way:

+--+----+-----+-----+-----+
|id|name| jar| jad| gif|
+--+----+-----+-----+-----+

| 1|a |a.jar|a.jad|a.gif|
| 2|b |b.jar|b.jad|b.gif|
| 3|c |c.jar|c.jad|c.gif|
+--+----+-----+-----+-----+

can anyone help? i need to do this via php

[pete_bisby]

If you've got the "id" as the primary key, then you won't be able to change the order unless you change the primary key to the "name".

If it's just for viewing purposes then a simple SELECT query shold suffice.

$qry = "SELECT * FROM games ORDER BY name";