#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    0
    Rep Power
    0
    Hi,
    I need to create a PHP / MYSQL DB where people can select what components they require from drop down menus - ie. processor / monitor / hard drive, etc etc.
    then upon submit their selections appear along with a price of how much it woudl all be. i`m a newbie so bear with me. i`ve managed to create the drop downs containing the data from the DB by connecting to the databsae by placing all the componenets in tables of their own. i`ve heard this is no good when i need to display them. can anyone provide a different method.

    Many Thanks

    rich
  2. #2
  3. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    6
    Rep Power
    0
    simple table suggestion

    Components
    int ID
    int Type <---> ComponentTypes
    varchar(80) Name
    int Price

    ComponentTypes
    int ID
    varchar(80) Type

    hope this will help u



    ------------------
    Greetings lewi

Similar Threads

  1. maysqladmin drop database syntax?
    By Slurm in forum MySQL Help
    Replies: 1
    Last Post: February 17th, 2004, 05:07 AM
  2. malloc and adding record to binary database file
    By shardservant in forum C Programming
    Replies: 5
    Last Post: January 24th, 2004, 08:28 AM
  3. layout ideas and suggestions
    By knera in forum Website Critiques
    Replies: 2
    Last Post: January 17th, 2004, 11:20 PM
  4. 2-dimensial array / mysql_fetch_array database problem
    By paulx82 in forum PHP Development
    Replies: 3
    Last Post: December 27th, 2003, 01:52 AM
  5. creating database & tables using ASP
    By pdxlooie in forum ASP Programming
    Replies: 2
    Last Post: December 26th, 2003, 05:27 PM

IMN logo majestic logo threadwatch logo seochat tools logo