Rearrange the display of the results after its been displayed

[NoobPHP]

I'm just curious if it is possible to arrange the results in Ascending order after it has been displayed.. That is to say, user clicks on the header of the column.. the results of the column will be rearranged in the Ascending order after it has been displayed..

[yktan]

If the items are in a dropdownlist, you can rearrange the items using javascript but if they are in tables, it's hard. I imaging you have to render each item in a <DIV> or something and use a javascript to get and set the innerHTML ...

[leatherback]

For the table, you need this script.
Untested, no warranty, take as-is. (I just collected it in my scripts bucket sometime back. Think it worked for me).

J.

<SCRIPT type="text/javascript"> 
      <!-- Hide this code from non-JavaScript browsers 
        DI_Split=','; // the separator character 
        Data_Items=new Array( // data to display 
          '1999-12-01,Jim,Yellow', 
          '1999-11-03,Tom,Blue', 
          '1983-03-12,Sally,Red' 
        ) 
        par=document.location.search.substring(1); // get the query string 
        if (par) { // sort needed 
          ix0=par-1; 
          SI1a=new Array(); 
          SI2a=new Array(); 
          Len=Data_Items.length; // number of rows 
          Switched=true; 
          while (Switched) { 
            Switched=false; 
            for (ix1=1; ix1<Len; ix1++) { 
              ix2=ix1-1; 
              SI1=Data_Items[ix1]; 
              SI2=Data_Items[ix2]; 
              SI1a=SI1.split(DI_Split); 
              SI2a=SI2.split(DI_Split); 
              if (SI1a[ix0] < SI2a[ix0]) { // need to switch them 
                Switched=true; 
                Data_Items[ix2]=SI1; 
                Data_Items[ix1]=SI2; 
              } 
            } 
          } 
        } 
        document.write('<CENTER>\n'); 
        document.write(' <TABLE border=1 cellspacing=2 cellpadding=2>\n'); 
        document.write(' <THEAD>\n'); 
        document.write(' <TR>\n'); 
        document.write(' <TH><A href="test22.htm?1">Date<\/A><\/TH>\n'); 
        document.write(' <TH><A href="test22.htm?2">Name<\/A><\/TH>\n'); 
        document.write(' <TH><A href="test22.htm?3">Value<\/A><\/TH>\n'); 
        document.write(' <\/TR>\n'); 
        document.write(' <\/THEAD>\n'); 
        document.write(' <TBODY>\n'); 
        Len=Data_Items.length; // number of rows 
        for (ix1=0; ix1<Len; ix1++) { // creating each row 
          DI1=Data_Items[ix1]; // a row of values 
          DI2=new Array(); 
          DI2=DI1.split(DI_Split); // split into fields 
          document.write(' <TR>\n'); 
          document.write(' <TD>'+DI2[0]+'<\/TD>\n'); 
          document.write(' <TD>'+DI2[1]+'<\/TD>\n'); 
          document.write(' <TD>'+DI2[2]+'<\/TD>\n'); 
          document.write(' <\/TR>\n'); 
        } 
        document.write(' <\/TBODY>\n'); 
        document.write(' <\/TABLE>\n'); 
        document.write('<\/CENTER>\n'); 
      // End hiding --> 
    </SCRIPT> 
    <NOSCRIPT> 
      You must have JavaScript to use this. 
    </NOSCRIPT> 

[LoganK]

Shouldn't this line:

<!-- Hide this code from non-JavaScript browsers

Be this:

<!-- // Hide this code from non-JavaScript browsers

[NoobPHP]

Thanks for all the replies.. but how should i use this script .. =)