How to connect to MySQL database

[wingpeople]

The service I use for Web hosting only offers MySQL (I could pay a lot more for an Access database, but I'm trying not to!). I've created a simple MySQL database on their server. I know what SQL Select statement I want to send it. What I haven't a clue about (and it's gotten worse in the hours I've just spent looking at FrontPage Help):

How do I connect to that database and have the single row that's the result of my query returned to me to display on a page?
(I know my host name, login name, password and name of the MySQL database, but I don't know much of anything else!)

Help!

 

[wingpeople]

OK, that was an extremely broad question I asked. I'm not really looking for a complete tutorial on ASP. But, can anyone point me to some documentation I can study to figure out where to go from here?

 

[FulcrumSys]

First let me say that I am in no way an expert in this area but I was researching the same issue. I am sure that ASP can probably access an ODBC connection but I was running into the same dead ends that you are in finding documentation. I have FP 2003 and would like to connect to a MySQL database also. Most documentation that I find points to Sharepoint. That being said, I was looking for something on the more economical side. I have found some references to PHP being run within Frontpage to access MySQL. I'm sorry, its been a few months since I was looking into this. I haven't been back to pursue it lately so I cannot be specific as to where I found these references. Hope it helps.