CodingForums.com - Resolved Going from XML to SQL

I have been trying my hand lately at trying to convert an xml file to SQL complient text file. I was told about XSLT and have been trying very hard but, as my username reveals, I am lost :)

I started researching and tried modifying the code found here but to no avail. Here is what my modification came out to look like right now:

Code:

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0" 

        xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 

        xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xsl:template match="/">

<html>

        <head />

        <body title="The Holy Bible">

                <xsl:for-each select="bible">

                        <p>

                                <xsl:for-each select="book">

                                        <xsl:if test="position( )=1">

                                                <table border="1">

                                                        <thead>

                                                                <tr>

                                                                                <td>Book</td>

                                                                                <td>Chapter</td>

                                                                                <td>Verse</td>

                                                                </tr>

                                                        </thead>

                                                        <tbody>

                                                                <xsl:for-each select="../book">

                                                                        <tr>

                                                                                <td>

                                                                                        <xsl:for-each select="@name">

                                                                                                <xsl:value-of select="." />

                                                                                        </xsl:for-each>

                                                                                </td>

                                                                        </tr>

                                                                </xsl:for-each>

                                                        </tbody>

                                                </table>

                                        </xsl:if>

                                </xsl:for-each>

                        </p>

                </xsl:for-each>

        </body>

</html>

</xsl:template>

</xsl:stylesheet>

I really do not know what to do about this for the code is not working as I would like. I want to output to look something like this:

Code:

INSERT INTO "bibletable" ("book", "chapter", "verse", "text") VALUES ('Genesis', 1, 1, 'In the beginning . . .');

INSERT INTO "bibletable" ("book", "chapter", "verse", "text") VALUES ('Genesis', 1, 2, 'And the earth was without form . . .');

...

...

INSERT INTO "bibletable" ("book", "chapter", "verse", "text") VALUES ('Revelation', 22, 20, 'He which testifieth these things . . .');

INSERT INTO "bibletable" ("book", "chapter", "verse", "text") VALUES ('Revelation', 22, 21, 'The grace of our Lord . . .');

Now if I cannot get it exactly like this I at least want to get as close as possible and I will use regex to do the rest.

Can you please offer me some advice? I would really like it.

If you want more info just say so. But, I hope this is sufficient to deliver the message.