HI,

I have selected first 30 rows from mysql query, and now i want to show all
records one-by-one (a record/per page). Please help me to code this function.

e.g. my query looks same as given below:-

select email, name, dob from users limit 30;

Regards

Nasik wrote:
> HI,
>
> I have selected first 30 rows from mysql query, and now i want to show all
> records one-by-one (a record/per page). Please help me to code this function.

Fairly easy to accomplish, depending on exactly how you want your data to be displayed, but a very quick and simple way to do this is with the Dynamic Table: Place the insertion point at the location where you want your data to be displayed, open up your Insert bar, go to the Data category, then select Dynamic Table. It's on the immediate right of the Recordset icon, in the drop menu. Within the UI that appears, select the name of your recordset, how many records to output (I'll assume you want to write out all of them) so check All records, then click OK.

For more advanced output, you can use the Repeat Region (second to the right from the Recordset icon, or in the Server Behaviors panel, click the + button and select Repeat Region).

The main difference between the repeat region and the dynamic table is that the dynamic table outputs all of the columns of your recordset as a table with the column names as the header for each column in the output table. This can work fro some folks, but for others you want more fine grained control of the output, and that's where the Repeat Region allows you to set up the display of one record with output area for each column of data that you want the end user to see, then you select that block of content and apply the repeat region. Voila, repeat content to your exact specifications.



--
Danilo Celic
| http://blog.extensioneering.com/
| WebAssist Extensioneer
| Adobe Community Expert