Get get into field from multiple rows

[vanman]

Hi

I need to get the results of multiple rows of the database into one formated field on a form.

Table is
bible_id
bib_bible_books_id
b_name
b_index
b_book
b_chapter
b_verse
b_nasb
b_nkjv
b_esv
b_isv
b_amp
b_niv

I need all the 'b_esv' rows that belong to a 'b_book' show in one large scrollable field on the form 'bib_bible_books_id' is the unique key for the book.

Thank

Paul

[kev1n]

Hi Paul

Could you upload a screenshot of a sample output what it should look like? (You could use Excel to illustrate it)

[vanman]

Hi Paul

Could you upload a screenshot of a sample output what it should look like? (You could use Excel to illustrate it)

Hi Kevin

Thanks for the reply

Option 1 is a dump group_concat I added the carriage returns

Option 2 could be useful but needs to be dynamic for each verse

Sample data attached.

btw the way each row has on average 130 characters and the upper group_concat would be 39,500 characters so group_concat may not work

Paul

[kev1n]

One possibility would be to use PHP and display the output in a html table:
https://forums.nubuilder.cloud/viewtopic. ... =10#p22121

[Janusz]

For long texts html is a good solution, works very fast - and you can easilly display hundreds of pages.
Just an example belowe - it's for different subject but it shows some possibility of it.
https://drive.google.com/file/d/1T5L5_s ... sp=sharing

[vanman]

Thank you

[admin]

Hey Paul,

How're things?


To get you started I've made a simple database you can use for your Bible stuff.

This is the table structure...

bible.PNG

You'll find a report you can play around with that looks like this...

report.png

Here is the database...

vanman.zip

Enjoy!


Steven

[vanman]

Hi Steven

Doing well, thank you for your help

Paul

[admin]

.