I have a spreadsheet that I can view with the power of PHP!...
php Code:
  1. <?PHP
  2.  
  3.    $file_handle = fopen("library.csv", "r");
  4.    
  5.   while (!feof($file_handle) ) {
  6.  
  7.    $text = fgetcsv($file_handle, 1024);
  8.  
  9.    print $text[1] . " . " . $text[2] . "<BR>";
  10.   }
  11.  
  12.    fclose($file_handle);
  13.  
  14. ?>
But what i really what to do is sort the information dependant on what the user selects.

My first column has "authers" (most repeated) If one auther is selected i want column two to only show books by that auther.

So can I create a link (mousedown varable) with a slice of information from a csv file?

And can I switch on/off rows in a csv file?

Thank for any help or direction!