nuBuilder Forum

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

Hi Paul

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

kev1n wrote: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

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

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

Thank you

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...
You'll find a report you can play around with that looks like this...
Here is the database...
Enjoy!


Steven

Hi Steven

Doing well, thank you for your help

Paul

.