SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Enthusiast
    Join Date
    Feb 2006
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Display Query Results by Groups - Help Please

    Assume theres are the following lines of a table:
    Make Model Year Model2 Part
    Ford T1000 1999 Auto 6500-01
    Ford T1000 1999 Manual 6500-02
    Ford T1000 1999 Deisel 6500-03


    I have a query that returns this data. I need to know display the data as follows.

    Make Model Year Model2 - as a HTML table header.
    PartNo Price PartNo Price PartNo Price - inside an HTML table (there are 4 parts only put one for simplicity)

    I must have this for each Model2. Can someone please help me accomplish this? Thanks
    Last edited by reservoir; May 11, 2007 at 17:25.

  2. #2
    Who turned the lights out !! Mandes's Avatar
    Join Date
    May 2005
    Location
    S.W. France
    Posts
    2,496
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Sorry I dont understand what result you are wanting to get, can you explain a bit more clearly, what do you mean by 'part inside a table' ??
    A Little Knowledge Is A Very Dangerous Thing.......
    That Makes Me A Lethal Weapon !!!!!!!!

    Contract PHP Programming

  3. #3
    SitePoint Enthusiast
    Join Date
    Feb 2006
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    edited it. Hope thats cleared up.

  4. #4
    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)
    is it a table or a query? where do PartNo and Price come from?

    the question is pretty vague about what you have, what you want, where it's coming from, and what you want to do with it
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


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
  •