PHP / MySQL coding for sub/$

Discussion in 'OT Technology' started by trueimage, Dec 4, 2006.

  1. trueimage

    trueimage Money from dirt OT Supporter

    Joined:
    Oct 23, 2006
    Messages:
    24,790
    Likes Received:
    1
    Location:
    Calgary
    Here is a sample table: (mine is larger with more columns and of course, different info)

    Code:
    id   name       type                desc
    
    0    apple       mcintosh          blah
    1    apple       granny smith     blah2
    2    apple       red delicious     blah
    3    orange      florida          blah3
    4    pear        bartlett         blah2
    5    apple       mcintosh         blah2
    
    I want to have an input feature on the website so users can submit info. But i don't want them typing apple, Apple, appel, aplep, APPLE, etc for "apple". I want to have a drop down menu to choose what is available (for some fields, not all)

    Also, I'd like to have it setup so when you choose apple in the first drop down, mcintosh, granny smith, red delicious are the only 3 options in there. I don't know how to set this up in the database either, for reading this info.

    Basically it is like Auto Filter in Excel.

    So, some fields will be drop down only, some you can type in (ie the desc field in this example) and some will have many options, but only display those contingent upon what is chosen in the previous, or specific drop down (ie type choices depend upon what is chosen initially in the name drop down). Also the fields that you can type in are to be limited to specific contents and limits (ie 0-9, length of 6 or alpha-numeric length of 30, etc)

    I would also like the option of en emailed entry if the option is unavailable, so I can manually enter it and the db doesn't get messed up.

    A "filter" feature that allows you to show/hide coulmns and sort / filter based upon what is in the columns is required. (ie only show rows that have name=apples and then click on desc to sort it ascending or descending)

    these are the two main features required: search/sort/filter and input, please PM me with a price/timeline and I might have thought of additional features at that time.

    Thanks!
     
    Last edited: Dec 4, 2006
  2. trueimage

    trueimage Money from dirt OT Supporter

    Joined:
    Oct 23, 2006
    Messages:
    24,790
    Likes Received:
    1
    Location:
    Calgary
    someone?
     
  3. Woodmaster

    Woodmaster New Member

    Joined:
    Dec 25, 2002
    Messages:
    15,448
    Likes Received:
    0
    Location:
    Brasil
  4. trueimage

    trueimage Money from dirt OT Supporter

    Joined:
    Oct 23, 2006
    Messages:
    24,790
    Likes Received:
    1
    Location:
    Calgary
    still looking
     
  5. trueimage

    trueimage Money from dirt OT Supporter

    Joined:
    Oct 23, 2006
    Messages:
    24,790
    Likes Received:
    1
    Location:
    Calgary
  6. jdw

    jdw New Member

    Joined:
    Dec 31, 2005
    Messages:
    4,429
    Likes Received:
    0
    Location:
    ND
    what's it worth to you?
     
  7. trueimage

    trueimage Money from dirt OT Supporter

    Joined:
    Oct 23, 2006
    Messages:
    24,790
    Likes Received:
    1
    Location:
    Calgary
    pm me with an offer
     
  8. Peyomp

    Peyomp New Member

    Joined:
    Jan 11, 2002
    Messages:
    14,017
    Likes Received:
    0
    Thank god Catalyst does this shit for me.
     
  9. crazybenf

    crazybenf Active Member

    Joined:
    Nov 14, 2001
    Messages:
    15,578
    Likes Received:
    2
    $150 2 hours after you give me all data+details
     
  10. SLED

    SLED build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    the newbs must all be taking finals :o they are usually all over this kind of stuff
     
  11. trueimage

    trueimage Money from dirt OT Supporter

    Joined:
    Oct 23, 2006
    Messages:
    24,790
    Likes Received:
    1
    Location:
    Calgary
    I kinda forgot about this, but I still want it done....
     
  12. trueimage

    trueimage Money from dirt OT Supporter

    Joined:
    Oct 23, 2006
    Messages:
    24,790
    Likes Received:
    1
    Location:
    Calgary
    pm replied still looking
     
  13. macistaniMac

    macistaniMac New Member

    Joined:
    Jul 6, 2006
    Messages:
    176
    Likes Received:
    0
    $200, done by 9pm tonight (CST)
     
  14. trueimage

    trueimage Money from dirt OT Supporter

    Joined:
    Oct 23, 2006
    Messages:
    24,790
    Likes Received:
    1
    Location:
    Calgary
  15. trueimage

    trueimage Money from dirt OT Supporter

    Joined:
    Oct 23, 2006
    Messages:
    24,790
    Likes Received:
    1
    Location:
    Calgary
  16. Slid.

    Slid. I'm a guy.

    Joined:
    Oct 25, 2001
    Messages:
    1,928
    Likes Received:
    0
    Location:
    NH
    What's wrong with the other offers? Too high, no response, too slow?

    When do you want it done and how much do you want to pay?

    [Answering either sets of these questions may get more responses for ya.]
     
  17. crazybenf

    crazybenf Active Member

    Joined:
    Nov 14, 2001
    Messages:
    15,578
    Likes Received:
    2
    .
     
  18. Peyomp

    Peyomp New Member

    Joined:
    Jan 11, 2002
    Messages:
    14,017
    Likes Received:
    0
    Sounds like a job for AHAH!
     

Share This Page