I'm a relative newbie to web design. I need to implement a database and allow queries and retrieval of data back to the client's html page. I'm somewhat confused about the process and I was wondering if I can be steered me down the right path.

I'm using MS-Access with a single table. I've uploaded it to the server. I know SQL syntax in order to retrieve data from the tables.

I understand that I need to connect to the database. I've seen several examples via Google on how to use php to connect to the database. I think I understand that process.

What I don't understand is the query, extraction, and presentation. If I have a html page with multiple selection options, I assume I need to send a properly structured SQL statement to the server. Assuming I have the correct statements for connecting to the MS-Access database and a properly structured SQL statement for data retrieval, how do I get the SQL results displayed back to the client's html page?

Tonynix,

You will probably get more accurate information in the Access forums. Good luck.

Hi Tonynix,

I use databases all the time, and I think you may be taking the wrong approach. Micro$oft Access, to my knowledge does not work with php, and I thought it did not work on-line, but have been corrected.

EDIT Looks like I was wrong in my assuptions, sorry

You could look up MySQl (free online database) used by millions around the world. It works extremely well with php, and runs on most Linux servers. If your web pages are hosted on Windows, then you may need to use ASP to connect to your database. Check with your server, see what you have and go from there. Your control panel for your website (most hosting packages have something like 'cpanel') will have a link to database software where you can create your on-line database.

After that, google up some php or asp tutorials, depending on what your server is and needs.

MS Access can certainly be used online. I have used this ASP and MS Access Forum software in the past with great success.

http://forum.snitz.com/

If you download the files there and look at the scripts, you will get an idea of what you need to do.

YAHOOOO! I learn something new every day. I have tried many ways to get a MS access database to work from an on-line system of some sort, with no luck at all! I gave up a long time ago. Now I just have to learn ASP

Looking to connect a MS SQL database. Anyone find a solution and use Coffee Cup? Thanks

Hi hkkul,
I use the HTML Editor to write all the code needed for Databases.