is this possible?
how do u do a database connection on xslt

There's no standard way of accessing a SQL database from XSLT, but some processors offer extensions to do it. See for example

http://www.saxonica.com/documentatio...ion/intro.html

A more standard approach would be to use the facilities of the SQL databse to create an XML extract of the required data, and pipeline this as an input document into the XSLT transformation.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

On this webpage there's a good example of connecting to a database

http://www.saxonica.com/documentatio...n/example.html

However i'm confused the way the drivers are managed
for example:

<xsl:param name="driver" select="'sun.jdbc.odbc.JdbcOdbcDriver'"/>
<xsl:param name="database" select="'jdbc:odbc:test'"/>

if i'm working with mysql, if i leave it the same, would that work? or the select inside the driver needs to changed?

also i was trying to follow the example but i didn't understand this part:

Register this database as a JDBC data source. (If you use Microsoft Access, register it as an ODBC data source called, say, Books, and then it will automatically be available under JDBC as "jdbc:odbc:Books".