Extract text from web page to database

[WoodGrain]

Hi guys,

What I'm wanting to do is provide a daily bible verse to subscribers to my web site.

Is there a way to extract specific text from a series of hyperlinked web pages into a database?

Is it possible to extract the bible text and store it into a database, or create a text file that contains SQL insert commands (probably better/easyer?) such that it retains it's correct structure?

http://www.biblegateway.com/versions/index...;vid=9#booklist

Please note that the linked bible is public domain.

So that each verse would:

- have it's own DB record (or insert)

- record it's book name (eg, Genesis), it's chapter number and it's verse number separately from the verse itself

For example, the SQL structure might look like: [book][chap][verse][verseText]

Realistically I think extracting to an SQL insert file would make more sense, but given the size of the completed file I imagine it would make more sense to perform the extraction such that each book creates it's own insert file.

Thanks!

[Valuater]

Daily verse with sound... Just for fun

#include <GUIConstants.au3>

$oIE = ObjCreate("Shell.Explorer.2")
GUICreate ( "Daily bible Verse... With Sound", 600, 360)
$GUIActiveX = GUICtrlCreateObj( $oIE, 0, 0 , 600 , 360)
GUISetState()

$oIE.navigate("http://www.biblegateway.com/usage/votd/votd2html.php?version=9&amp;jscript=0") 

While GUIGetMsg() <> -3
Wend

8)

[Valuater]

Cut out the web site

#include <GUIConstants.au3>

$oIE = ObjCreate("Shell.Explorer.2")
GUICreate ( "Daily bible Verse... With Sound", 600, 75)
$GUIActiveX = GUICtrlCreateObj( $oIE, 0, 0 , 600 , 360)
GUISetState()

$oIE.navigate("http://www.biblegateway.com/usage/votd/votd2html.php?version=9&amp;jscript=0") 

While GUIGetMsg() <> -3
Wend

8)