viewing/display contects of database on website

how?

[Blelisa]

Hello,
I have used .asp and SQL to create many web pages that interact with my database. For instance, I have a page that updates an entry in my database, a page that inserts entries in my databse. However, I want to know how to write a page that will show all my database info.
What I mean is I have a database that holds info regarding troubletickets. I want a page that "view all tickets" and will give back all the information in the database. I would put the information in a table for easier viewing.

Does anyone know of a good tutorial for this or how to go about this?

Any help is greatly appreciated.

[txbakers]

It's very easy:

<table>
<% do while not recordset.EOF %>
<tr>
<td><%= your information here %>
</tr>
<% loop %>
</table>

I'll leave the formatting up to you.

don't forget the "loop" or "move next" or however the syntax requires you to move to the next record or you will crash the server.