Click to See Complete Forum and Search --> : Formatting Select Results...


CSmith1128
01-29-2004, 03:20 PM
I was wondering how i could format the way SELECT results are disaplyed.

For example, if i wanted to get information from multiple rows from a table, and then display them on a table on a website with a line separating each row on the table.

Example...

Name Address City State Zip

C 435 mill st. town NJ 09023
__________________________________________________

J 435 mill st. town NJ 09023
__________________________________________________

M 435 mill st. town NJ 09023

Khalid Ali
01-29-2004, 03:57 PM
I am guesing by select you mean a SELECT query resultset from a DB,if so then you will need to iterate thru the restult set and for each set create a new <tr>...</tr>
that will create new row for each record

CSmith1128
01-29-2004, 05:31 PM
and to do this you would do what?

would you use a while loop or what?