Displaying select data for dropdown list

Discussion in 'MySQL' started by Creepn, May 24, 2008.

0
  1. #1
    Guys im a total database newbie here so I need some help please.

    Im building a retail clothing website. When the user clicks on a certain outfit, it will take the user to another page that will have the user select the size of the outfit from a dropdown menu. SMALL, MEDIUM, LARGE, ONESIZE. Some of the outfits only have 2 sizes or 3, not all of them.

    So what do I put in the database so the select information can be displayed for the appropriate outfit in the drop down menu?

    Im using ASP.NET and MySQL.
     
    Creepn, May 24, 2008 IP
  2. waz

    waz Active Member

    Messages:
    263
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    55
    #2
    Google is your best friend, use it. :)
     
    waz, May 24, 2008 IP
  3. Creepn

    Creepn Peon

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I did google it. Their instructions arent specific to what Im trying to do. I want to display select data for different products. The intructions I found ends up displaying all of the sizes (s,m,l, onesize) in the drop list box.
     
    Creepn, May 24, 2008 IP
  4. Creepn

    Creepn Peon

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Well it looks like mySQL doesnt have a yes/no data type like Access. What is mySQL equivalent data type to Access's "yes/no" data type?
     
    Creepn, May 25, 2008 IP
  5. allaboutgeo

    allaboutgeo Peon

    Messages:
    85
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #5
    For yes/no you can use TINYINT with 1 for yes and 0 for no.
     
    allaboutgeo, May 27, 2008 IP