hi all

i am creating a navigation list(Categories + sub categories) in the left bar of my website.

Each Category has around 5-7 sub categories under them.

Code:
MOBILE PHONES (this is category name)
1) Nokia (these below are sub categories)
2) Samsung
3) Sony
4) Motorola
5) Apple
6) Blackberry
at present they are displayed in a general loop acording to the number they were entered.

now i want to change the "display order" of sub categories.

means I want to move
Code:
"Sony" at No. 1
"Blackberry at No.2
"Samsung" at No. 3
at present this is my query
PHP Code:
$leftqry="select * from dealer_table where category_id=1";
$leftresult=mysql_query($leftqry);
while(
$leftrow mysql_fetch_array($leftresult))
{
echo 
"<tr>";
echo 
"<td>" "<a class='leftnav' title='".$dname"-"$cname"' href='http://localhost/mobiles-".$leftrow['dealer_id'] . "-" .$leftrow['category_id'] ."-".$dname."-".$cname.".html""'>&raquo; &nbsp;" .$leftrow['dealer_name']. "</a></td>";
echo 
"</tr>";

what should i do

vineet