www.webdeveloper.com
Results 1 to 2 of 2

Thread: Need a sql query for..........

  1. #1
    Join Date
    Jul 2008
    Posts
    9

    Question Need a sql query for..........

    Hi all,

    I need a sql query for:

    table: p2c
    pid cid
    1 1
    2 1
    3 1
    4 2
    5 3
    6 3

    I want to display a HTML table like this:

    1 2 3 <-------- unique cid
    -----------------------------------------------
    1 4 5 <--------- pid
    2 6 <--------- pid
    3 <--------- pid

    Thank you in advance!

  2. #2
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    ok... and why do you think this is purely sql? the best i can think of is to make dynamic sql, but really the display of the data has little to do with how it's stored. it's really about your programming language and how it can give you this in a usable state.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles