I have tried writing a query script to display my Bible database like this one:
[URL=”http://www.biblegateway.com/versions/?action=getVersionInfo&vid=49″]http://www.biblegateway.com/versions/?action=getVersionInfo&vid=49
I’d like to receive help on this if I could.
Here is a snippit of the sql file I used to set up my database:
[code=php]INSERT INTO bibleasv VALUES (1, 1, ‘Genesis’, 1, 1, ‘verse 1 goes here’);
INSERT INTO bibleasv VALUES (2, 1, ‘Genesis’, 1, 2, ‘verse 2 goes here’);
INSERT INTO bibleasv VALUES (3, 1, ‘Genesis’, 1, 3, ‘verse 3 goes here’);
INSERT INTO bibleasv VALUES (4, 1, ‘Genesis’, 1, 4, ‘verse 4 goes here’);
INSERT INTO bibleasv VALUES (5, 1, ‘Genesis’, 1, 5, ‘verse 5 goes here’);
Here is the table setup:
[code=php]TABLE -> bibleasv – id, number, book, chapter, verse, text
All the queries I have tried list the chapter for each verse, so you end up with as many chapters as you have verses in that chapter. And it runs across the screen instead of automatically dropping dow to the next line in the table cell.
I want to show the chapter name in the left cell and the chapters in the right cell linked to a page that will display all the verses in that chapter:
[code=php]<a href=’passage.php?file=$chapter’>$chapter</a>