Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Apr 2013
    Thanked 0 Times in 0 Posts

    Placing MySQL data onto HTML webpage

    Gentle people:

    I am in desperate need of coding help.

    My project is a database on heavy metal bands $DBName = bands;

    I wish to extract data from the 4 tables I have in this database and place them on an php or html page.

    Table 1 is Bands (col 1 Band, col 2 Years Active)

    Table 2 is Discography (col 1 Band, col 2 Album, col 3 Year Released)

    Table 3 is Musicians (col 1 Band, col 2 Last name, col 3 First name, col 4 Position, col 5 is Year with band)

    Table 4 is Songs (col 1 band, col 2 album, col 3 song)

    On the php or html page I want to pull current members (present is in the years with band) and place at top; place discography below that; place songs below that, then place all past members...

    Everything I have tried has failed horribly...

  2. #2
    Regular Coder
    Join Date
    Apr 2004
    Thanked 23 Times in 23 Posts
    1. Show what you have tried.
    2. Define "failed horribly"

  3. #3
    Regular Coder
    Join Date
    Jun 2012
    Thanked 0 Times in 0 Posts
    Why not use an array on the page instead of mysql?

    Then create the display table on the fly and show the info.

    This is how I"m doing it on my site and works quite well.


Posting Permissions

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