Urgent

[gopi nath <gopivsb@xxxxxxxxxxx>]

my table is
  tbl_media (tablename)
 id_media,name,photo,status.(table fileds)

i displayed the table. show the records.. 

 $s = "select * from tbl_media";
 $q = mysql_query($s);
while($r = mysql_fetch_array){
  echo $r['name'];
}
status value A -Active , I-Inactive
i need the table fist display the status value 'A' after status value ''IA; how to fix that?
for example first four records Status =A and remaining are Status=I



      Now surf faster and smarter ! Check out the new Firefox 3 - Yahoo! Edition http://downloads.yahoo.com/in/firefox/?fr=om_email_firefox

[Non-text portions of this message have been removed]