I have a "time sheet" form that I've created in Livecycle Designer. It's going to interface with software that holds a database in MySQL. My understanding was that LCD doesn't play well, if at all, with MySQL. I wrote a PHP script that converts the entire MySQL database to an XML database.
So on my server I have database.xml.
I have created a data connection to database.xml in the form, so the architecture of the connection is set up. If I open the form in Acrobat Pro, I can manually import data from database.xml, but only from Pro and only if I know where the file is.
Once this is done, I have a drop down menu that these fields are populated into.