Pull data from MySQL to display in table

Hello again!

What i'm trying to do is to pull 5 feilds from my users table to display on my admin_index page, which will contain clients hosting, password and domain expiry information. I created a recordset that contains all these fields, then got stuck trying to figure out what the next steps would be.

I'm pretty sure I know how to get these things to display on the users_Profile page using session variables, but i'm nor sure how to get them to display on my admin_index page. I had a look at the results page to see what the code was doing to display all those records, but I couldn't quite get a grasp on what i'd need to do to make it work.

Any help?

Thanks in advance :)

create a table with 1 row and 5 columns.

Open the bindings panel, and expand the recordset binding group.

Drag the binding for each recordset column into the a cell of the table.

In the tag inspector, select the tr tag, then go to the server behavior panel and click the plus button. Select repeat region to add a repeat region around the table row to loop through the recordset and create a new table row for each result.

Thanks Jason,

I did all those steps, but the data still isn't appearing?

Nevermind, I figured it out. I just had my recordset configured incorrectly. Thanks!

Ok, glad to hear it is working.