[question] using XML to display data from database

[subhash]

I am a bit confused here..

I have a table that looks like the following:



Right now, I only have made two of them, but there will be close to 100 in the actual database. I know how to retrieve the values from the database, but I am not sure how to make it in a loop or in a certain format.

For example, what I am looking for is for it to take the info from the DB, and when someone views the page, it formats it in a certain way. For example, for the 1st one, it would be:

Charlie B. Payton
Payton Place Brokers, Inc.
P.O. Box 468301
Atlanta, GA
404-364-6428
cbp@payton-place.com

and next to it would be the information for the next realtor, and I want to make it only put two realtors in the same row, and then go to the next one, and keep going through the whole DB doing that until it gets to the end...I just dont understand how it would work. Anyone have any simple examples or links that would be useful?

I dont have PHP, and I dont really understand the code simu posted..would it be similar to do it in ASP?

Thanks for all the help.

Subhash

[weblogic]

You have some serious fundamental issues.

You should hit some asp websites or pick up some books on the subject.

[aspfreakout]

So open the db, execute the query, then do something like:
Do While not myrecordset.EOF
Response.write(myrecordsert("Name"))
Loop


-------------------------------------------
Maybe it's just you, looking bad!

[subhash]

thanks...

Subhash