Show Data in table
I would like to show my data as in the attached image. Attachment 58848
In my sql database the records are as follow:
John smith ClientName1
John smith ClientName2
So how can I show the services by driver name?
Does anyone know how to do it?
Fetch the details from the database after connecting with them.
Do While Not rset1.EOF
For i = 0 to rset1.Fields.Count - 1
Response.Write "<TD>" & rset1.Fields(i) & "</TD>"
This should help..for more details.. you can check google...it will come up with several explanations.
I have done what you told me, but I m getting the result like this:
and what I want to achieve is to populate the data by driver with this structure: