SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Jan 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post Show Data in table

    Hi.

    I would like to show my data as in the attached image. table.jpg

    In my sql database the records are as follow:
    DriverName ClientName
    John smith ClientName1
    Peter ClientName8
    John smith ClientName2


    So how can I show the services by driver name?

    Best regards

  2. #2
    SitePoint Member
    Join Date
    Jan 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Does anyone know how to do it?

  3. #3
    SitePoint Member
    Join Date
    Jul 2011
    Posts
    14
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Fetch the details from the database after connecting with them.

    Use

    rset1.MoveFirst
    Do While Not rset1.EOF
    Response.Write "<TR>"
    For i = 0 to rset1.Fields.Count - 1
    Response.Write "<TD>" & rset1.Fields(i) & "</TD>"
    Next
    Response.write "</TR>"
    rset1.MoveNext
    Loop

    This should help..for more details.. you can check google...it will come up with several explanations.

  4. #4
    SitePoint Member
    Join Date
    Jan 2012
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi carhirecyprus

    I have done what you told me, but I m getting the result like this:

    Driver1
    ClientName1
    Driver1
    ClientName2
    Diver1
    ClienteName3
    Driver2
    ClientName50

    and what I want to achieve is to populate the data by driver with this structure:

    Driver1
    ClientName1
    ClientName2
    ClientName3

    Driver2
    ClientName50
    ....
    ,...


    Driver3
    ....


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
  •