SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Thread: Sortable table

  1. #1
    SitePoint Zealot thorbergdt's Avatar
    Join Date
    Jun 2004
    Location
    Fantastic US of A
    Posts
    124
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Sortable table

    I have a client asking me for:
    I have attached a spreadsheet that very likely will get updated every month or o; I’d like this to be sortable, ie, click on the category, and it sorts alphabetically for the user. And for every unique user, it would be reset to be alpha by name (the left hand column). The tricky part is that I would also like each ‘groups’ clinic name to be hyperlinked to their own websites (sites included on the word document)
    so yeah.. pretty easy so it sounds he will send an updated excel file every few months, just wondering what might be the quickest easiest way of developing a page. Thanks,
    World of Warcraft - Resources (items,quests,mods). itemvault.com
    ArcadeApe.com Tons of free games, come and monkey around!
    Customize your MySpace with our tips and tricks! MySpaceApe.net
    twincitiesforum.com A Minnesota general chat forum.

  2. #2
    I meant that to happen silver trophybronze trophy Raffles's Avatar
    Join Date
    Sep 2005
    Location
    Tanzania
    Posts
    4,662
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    You will almost certainly have to use a server-side scripting language such as PHP. Ideally your script would take the excel spreadsheet and parse it, then put all the data into something usable, most likely a set of arrays. Then using those the HTML can be generated and by clicking on the category the arrays can be sorted accordingly. It would also be easy enough to attach a hyperlink to each item.

    The most difficult thing I can foresee is the parsing of the spreadsheet. Since Excel will throw in a lot of junk along with the actual data, it might be worth asking the client to save it as a CSV or you can do this yourself. A CSV would be easier to parse.

  3. #3
    \m/\m/ karinne's Avatar
    Join Date
    Dec 2002
    Location
    Aylmer, QC, Canada
    Posts
    409
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  4. #4
    SitePoint Wizard
    Join Date
    Jul 2003
    Location
    Kent
    Posts
    1,921
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Here's another one that uses javascript

    http://mickweb.com/football/aleague/profiles.html

    It uses a different function for each column

  5. #5
    SitePoint Zealot thorbergdt's Avatar
    Join Date
    Jun 2004
    Location
    Fantastic US of A
    Posts
    124
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Awesome thanks for the ideas, I didn't really want to get involved with a big database seeing how there are only 10 or so people on the list! I put one into use here http://www.orthopedicfitness.com/physician-finder.php
    World of Warcraft - Resources (items,quests,mods). itemvault.com
    ArcadeApe.com Tons of free games, come and monkey around!
    Customize your MySpace with our tips and tricks! MySpaceApe.net
    twincitiesforum.com A Minnesota general chat forum.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •