$query=mysql_query("Select * from $table order by id");
it display some results order by id like
table
id |catagory
1 | s
2 | a
3 | d ....
my problem is i want to make id of catagory a=3 and d=2 to change the order like
1 | s
2 | d
3 | a ......
or there is any other way to perform that like i saw some uses
id | catagory |cat_order
1 | s |10
2 | a |20
3 | d |30 .....