Just a few hints I've learned when using the ODBC Connector (MyODBC) to access a MySQL database:
1. Use Double instead of Float datatypes
2. Include a Timestamp field
3. Always define a Primary Key
4. Avoid Blob datatypes.
in your notes you have the database username and password being displayed on the html page the you are using to call the fuction files. Am i reading that wrong, but isnt there a more secure way of doing this than showing the info on the html page
Actually, while they are there in the page source, they will not show up in the generated web page, as it is PHP code that gets interpreted out at the server. As long as you have the directory on your server protected, no one will ever see the username and password.