Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Recordset selects first 30 rows (PHP)

Guest
Sep 01, 2008 Sep 01, 2008
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
TOPICS
Server side applications
237
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Sep 01, 2008 Sep 01, 2008
LATEST
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
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines