SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Addict
    Join Date
    May 2002
    Location
    Louisville, KY
    Posts
    238
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help with query?

    I have a huge table with 100,000+ records of songs on CD's. Each record has information regarding the CD including a disc_id that identifies the CD that the track is on.

    Ultimately I need to display the Disc with the tracks in a description. I am using PHP. How can I do this with 100k records, possibly 10k disc's? Do I use a subquery or something?

    Thanks,
    Josh

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,216
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by jpfour23
    ...display the Disc with the tracks in a description.
    could you give an example? i don't see where the subquery would come in
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Addict
    Join Date
    May 2002
    Location
    Louisville, KY
    Posts
    238
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I wasn't sure if this would be more of a MySQL question than PHP so I posted more info in the PHP forum:

    http://www.sitepoint.com/forums/showthread.php?t=236403

    Thanks


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
  •