SitePoint Sponsor

User Tag List

Results 1 to 7 of 7

Hybrid View

  1. #1
    SitePoint Addict
    Join Date
    Aug 2000
    Posts
    248
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Database Design Block

    I am drawing a complete blank on designing a table structure for this page:
    http://216.119.95.149/whataconcept/dcfcu/listrates.asp

    I need to make the "savings programs" table at the top dynamic however, I need to have the ability to "move" the actual savings program name ("share savings" for example) up or down in the display dynamically. Obviously if the savings program name moves, it's corresponding monetary range($100-$499,$500 - $999, etc for example), APR and APY have to move with it.
    I am by all means blank on how to approach the design of this table(s) and any help or hints would be greatly appreciated.

    Thank you

  2. #2
    SitePoint Wizard silver trophy TheOriginalH's Avatar
    Join Date
    Aug 2000
    Location
    Thailand
    Posts
    4,811
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Do the various programme names have corresponding numerical values? If so, you could have a table to "move" them around. ie: order table: with 2 columns
    one being ordered (1-5) the other with changable values (relating to the value of the programme). A little scripting and you'll be moving stuff around in no time.

    H
    ~The Artist Latterly Known as Crazy Hamster~
    922ee590a26bd62eb9b33cf2877a00df
    Currently delving into Django, GIT & CentOS

  3. #3
    SitePoint Addict
    Join Date
    Aug 2000
    Posts
    248
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I was thinking that but how in the heck would i move/display the monetary ranges so that they are related to the savings program that they belong in? At the bottom of the page I created that simple table by using a numeric field called "PageLocation" and I sorted by that but the above table brings in other variables such as the monetary ranges. I guess the problem I am having is setting up the table so that when I create the loop and then display it it shows up in the format below while still being able to move the program name along with its monetary ranges as a GROUP.

    Share Savings


    $100 - $499.99 1.75% 1.76%
    $500 - $999.99 2.00% 2.02%
    $1,000 - $4,999.99 2.25% 2.27%
    $5,000 + 2.75% 2.78%

  4. #4
    SitePoint Wizard silver trophy TheOriginalH's Avatar
    Join Date
    Aug 2000
    Location
    Thailand
    Posts
    4,811
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    mmmmk.

    Table: Programme as before.
    Table: Programme Details (with associated Programme ID).

    Something like that?
    ~The Artist Latterly Known as Crazy Hamster~
    922ee590a26bd62eb9b33cf2877a00df
    Currently delving into Django, GIT & CentOS

  5. #5
    SitePoint Addict
    Join Date
    Aug 2000
    Posts
    248
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm afraid that I am still drawing a blank. sorry.

  6. #6
    grasshoppa Snowbird122's Avatar
    Join Date
    Apr 2001
    Location
    Austin
    Posts
    353
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I could help you if you could explain your problem a little more clearly. What do you mean about making the title "move". What exacly is the problem?
    http://www.echo-consulting.net - Sound Solutions for Online Inspriations.

  7. #7
    SitePoint Addict ownersite's Avatar
    Join Date
    Jul 2001
    Posts
    222
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you have a table that maintains the list of savings types, why not add a field for row order and sort the query results by that number?
    F150online- 102,000 users strong and growing...
    Ownersite.com
    - tools to enhance vehicle ownership


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
  •